Create additional output file only if condition is met

[myang2021]

Hello everyone,

I want to add a data checking process to my existing Alteryx workflow to catch potential errors. The existing workflow creates a normal output file like below:

ID	Weight
A	10%
B	82.50%
C	7.50%

The data checking process in my mind should monitor the "Weight" column. If the total weight is not equal to 100% then a extra output file ("checking file") should be produced and saved down. if total weight is 100% then no checking file should be produced.

Any help would be appreciated.

thanks.

[atcodedog05]

Hi @myang2021 

Here is how you can do it. Enable/Expand the container one at a time to check the 2 scenarios.

Workflow:

Hope this helps : )

[myang2021]

This is exactly what I am looking for. Thank you so much!

[atcodedog05]

Happy to help : ) @myang2021 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!