Creating a Pass/Fail Test in Magic ETL
I am trying to create a pass/fail test in magic ETL.
There are four test it needs to go through to pass or fail. Once a row is listed as fail I would want all the rows matching that submission ID to fail as well how would I go about this or what is the correct formula to use?
for example It failed the first test but passed the next three. Since the first test failed I would want each row under it to say fail as well…
Here is the formula to determine a pass/fail for reference:
CASE WHEN Critical/Major
= 'Major' AND No
>= 2 THEN 'Fail'
WHEN Critical/Major
= 'Critical' AND No
> 0 THEN 'Fail'
WHEN Critical/Major
= 'Major' AND No
= 1 AND Critical/Major
= 'Common' AND No
>= 2 THEN 'Fail'
WHEN Critical/Major
= 'Common' AND No
>= 3 THEN 'Fail'
ELSE 'Pass' END
Thanks
Answers
-
@gbrown I would suggest doing this by splitting your dataset once you have the Pass/Fail beastmode created as written. Have a branch that filters to just the fail rows and then you can select just the Submission ID and Pass/Fail columns and then use the Remove Duplicates tile. Then just join it back to the “original” branch of your dataset using the submission ID and you'll have all ID's with a single fail marked as fail.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2 -
Alternatively you can use a group by tile and select the minimum value for your pass fail column and join it back to your original dataset that way if any are marked as fail all would become fail.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
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
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive