Create exception report based on a condition and stop processing the output

[PrasadP]

Hi Community,

How to create exception output report based on a condition(if Count of Col A>0), that says Col A has these many exceptions and also stop processing the actual output from Alteryx.

Regards,

Prasad

[adamorse]

Have you tried a message tool like in the screenshot? (Also see attached workflow).The "Before first rows where expression is true" combined with "Error and stop passing records through this tool" should combine to cancel the workflow and display the error message before processing the first exception where Col A > 0.