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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 646 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 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