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!
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board