Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data matching: how to output report that all data points have matched

samstar85
7 - Meteor

I am matching two documents and have added a pass/fail column, which I'm using to filter out any lines which haven't matched. Is there a way to report that all lines have matched as just no output is given from the Render tool using pdf when everything has passed the check.

 

I'd also like to show the total no of records and how many have passed/failed in my output if possible.

 

This is where I am so far, any suggestions to improve this workflow would be greatly apricated.

 

Filter.PNG

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

Throw a count tool onto the true anchor, this will always generate a single record, with either 0 or however many errors.

 

Then add a filter tool tool onto this stream, keeping only the row if the value is 0.

 

Then right another PDF output, to indicate 'perfect match'.

 

You could probably write this to the same place as the PDF if the fails occur.

 

Ben

samstar85
7 - Meteor

Thanks so much

Labels
Top Solution Authors