Create additional output file only if condition is met

Question

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:

IDWeightA10%B82.50%C7.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 · Answer

Happy to help : ) @myang2021

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

Cheers and have a nice day!

myang2021 · Answer

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

atcodedog05 · Answer

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 : )

checking file.yxmd