Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi Community!
I would like to be able to have an automated scenario that runs through if a dataset's record count metric is > 0 but halts (also with SUCCESS) if the record count metric == 0.
More specifically, and by way of illustration, a scenario that does:
Step#1: build dataset A
Step#2: compute metrics on dataset A
Step#3: set a scenario variable v = row count metric on dataset A
Step#4: build dataset B if v > 0
Any ideas would be really welcome, thanks!
Nik
Hi Nik,
You can add a check on the metric row_count.
A check is a condition that depends on a metric, here the check would be a success if it's above or equal 1:
If not the check is going to fail.
So then in your scenario
- step 3 is: run this check.
- step 4 is: build dataset B if no prior step failed. (you have this option in the step options)
Matt
Hi Nik,
You can add a check on the metric row_count.
A check is a condition that depends on a metric, here the check would be a success if it's above or equal 1:
If not the check is going to fail.
So then in your scenario
- step 3 is: run this check.
- step 4 is: build dataset B if no prior step failed. (you have this option in the step options)
Matt
Thank you Matt!
I've accepted this at it gets what I need done, done - is there a way that I could have such a scenario conclude in a SUCESS, however? The build doesn't happen, which is great, but this isn't really a failure - everything has run correctly...
Thanks again,
Nik
niko, if you are still looking for an answer on how to do this without failures look at my post: