Comparing 2 inputs with same data and multiple columns

Question

Hi,

I am trying to compare and validate my data following a new ETL process. I have 2 csv-based input files where one is derived from Prod and one from a new ETL process but should contain the same mirrored data. I used join tool to match my columns as the column headers are the same and I got pretty close matches. However, I want to do comparison for each column so I know where I can identify where there is a mismatch and the specific columns where data doesn't validate.

Alteryxcompare.PNG

CharlieS · Answer

Check out this example from my "What the XML?" Inspire presentation called "Table style rules". I use a batch macro to edit the XML of a Table tool to highlight fields in two tables that differ for a nice visual comparison.

Of course this workflow can be modified to join on a field rather than position, or output to Excel if you prefer (might be better with larger datasets). Let us know if you have any questions!

What the XML - Table Style Rules.yxzp

cjaneczko · Answer

Try This. You'll need to update the Prefix on all of the fields with Prod for production and Dev for Development. This only shows record that have variances. Any matches are dropped.

New Workflow4.yxmd

akshatbabbar · Answer

Thanks for the quick response back, is there a faster way to do it because I am working with around 50 columns in each dataset.