Magic ETL or Beast Mode?
I'm using data that basically needs an (=if) statement like we were going to be using excel--
We have two columns called current income and qualified income. The 'income' column needs to populate with 'current income' if another column, called 'instrument' reads 'first home' otherwise, we need to use qualified income to populate the new column called 'income'.
Is the best way to do this using a beast mode? or what tile would i use in magic ETL? im lost as to how i would do either of them as well. Any and all info would be greatly appreciated.
If this helps, feel free to agree, accept or awesome it!
@damen I would recommend using a beast mode and sharing it on the dataset. That way if you need to tweak it, you can do it in the analyzer and get the update right away without having to edit the ETL and run it.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
There are perks for having something as a beast mode and perks for having something in an ETL.
If something needs to be recalculated on the fly utilizing a filter then I'll go with a beast mode.
Most of the time I'll try and put calculations into the Magic ETL so that the processing may take a fraction longer to prepare the data but won't give a negative UI experience if there are too many beast modes saved to a dataset. Whenever a card is rendered all beast modes are evaluated whether or not the beast mode is actually used on the card. This can cause delays when rendering a page giving a poorer user experience.
In your case it doesn't sound like you'd need to have filters applied so I'd recommend putting it into the ETL you're using to prepare the data. You can use a formula tile to do many similar operations as a beast mode (except window / fixed functions).
You can use @Jones01 's formula to conditionally set the value based on your logic.**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
- 7.6K All Categories
- 913 Connectors
- 241 Workbench
- 470 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 24 Visualize
- 194 Beast Mode
- 2K Charting
- 6 Variables
- 14 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 18 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部