Reconcillation of Excel in Alteryx by Comparing and Generate an Exception Report

[rohit782192]

Hi ,

How could i generate the exception Report for the same. if there would be a macro which compare the full excel and generate the excepion report that would also work.

COL1	col2	FALSE
APPLE	apple	TRUE
LIME	LIME	TRUE
	ROSE	FALSE

Output:

EXCEPTION IN COL1 : Line 4
EXCEPTION IN Header Mismatch : Line 1

[ChrisTX]

See attached workflow.  This should point you in the right direction, with a little more work to do.

 

Chris

[ChrisTX]

@apathetichell I like your style.  Makes perfect sense.