Value Map all columns at once

Is it possible within an ETL to value map all the NULL values in all the columns within one function. When joining datasets and keeping all the columns there end up being NULL values all over the place. This has been notorious for making Beast Modes fail. My fix for this is to add a bunch of value map functions at the end of my ETL to map all these columns. I feel like there has to be a quicker, easier way to do this. I also think there is a Beast mode function 'IFNULL' but i would prefer not to have to do that on every single one. I was just curious if I could map it all at once within one value mapper function.
An additional goal of mine is to create more efficincies within my ETL by reducing the amount of data and functions. I have noticed the value mappers and Rank & Window functions take a large amount of time. Any tips for making ETLs run faster would be appreciated as well.
Comments
-
Currently I don't beleive Domo supports a table wide NULL mapping but it requires multiple mappings - one for each column.
This would be a great idea for the idea exchange. I'd definitely vote for it.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 74 App Studio
- 43 Variables
- 727 Automate
- 186 Apps
- 466 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive