Magic ETL Conditional Column
Hello,
I am brand new to Domo and looking for the equivalent data transformation in Power BI that is called "Add Conditional Column" which basically allows you to write a case statement based on values in existing columns in your data set. Ex. If [Sales Rep] = "Dan" and [Order Type] = "1" then "Exclude" else "Include".
Is there a way to achieve this without filtering, adding a constant, then appending that back to the data set? (this was how a co-worker instructed me)
Or would this be a situation where just writing it in SQL would be better?
Thank you!
RS
Best Answer
-
@remember_Sagan Your co-worker was right on the filter/constant for Magic ETL. But being better than SQL is hard to say. I say that because yes it may be more complex to set up this situation in MagicETL, but the performance of the execution of this ETL will most likely always be much better than whatever you did in SQL. This may not apply so you'd have to decide that, but if you went from 1k rows of data to 1M rows of data in SQL, you're most likely going to tell a difference in the execution of that SQL statement, but you would probably never notice it in Magic ETL.
Hope that helps.
Matt
1
Answers
-
@remember_Sagan Your co-worker was right on the filter/constant for Magic ETL. But being better than SQL is hard to say. I say that because yes it may be more complex to set up this situation in MagicETL, but the performance of the execution of this ETL will most likely always be much better than whatever you did in SQL. This may not apply so you'd have to decide that, but if you went from 1k rows of data to 1M rows of data in SQL, you're most likely going to tell a difference in the execution of that SQL statement, but you would probably never notice it in Magic ETL.
Hope that helps.
Matt
1 -
I am more comfortable using MySQL, so I agree with your statement that I think this is easier using a MySQL dataflow
SELECT
CASE WHEN `Sales Rep`='Dan' AND `Order Type`='1' THEN 'Exclude' ELSE 'Include' END AS `Conditional Column`However, if the dataflow is already built in ETL, then I would recommend just using three steps mentioned.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive