Conditional ETL Run
Hey experts
I have Sales data for US states with two columns - State, Sales.
The data is received in Google sheet and I want to make sure that there is no typo in the State column, prior to using it in Magic ETL.
I created a master data that contains all the correct state names. I then right joined my Sales Data with master data with filter “State is null” using SQL data flow. This gives me all rows with misspelled State names in my Sales Data. The output is called “Misspelled States”
Next, I want to run my Magic ETL only if “Misspelled States” is empty.
Is it possible to do that in Domo? Any other suggestions on how this can be achieved will be highly appreciated.
Regards
Comments
-
Hnrgh...
well ... no. you can't conditionally run execution. What you could do is count the number of errors and export that with your first pass ETL (although, I would probably just integrate both ETLs into one stage).
if you have a recursive dataflow in place you could set the rule "if countOfErrors = 0 then ... replace your sales data witth new ETL" and "if count ofErrors > 1 then output the input dataset without changes."
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"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