Hi community !
I am new to Alteryx and I need your help.
I have to compare the data from two different sources. See sample datasets and my workflow below.
Columns are like : Name from source 1, Name-ERP from source 2, Name check ( TRUE or FALSE) as my result comparison.
Source 1: Given data before cleansing
| RowID | Name | City | Email | Country |
| 1 | Amazon | Paris | info@amazon.com | FR |
| 2 | FB | New York | info@facebook.com< | US |
| 3 | IG | NY | info@IG.com | USA |
| 4 | Dior | London | info@dior.com | UK |
Source 2: Uploaded data after cleasing
| RowID | Name_ERP | City_ERP | Email_ERP | Country_ERP |
| 1 | Amazon | Paris | info@amazon.com | FR |
| 2 | Facebook | New York | info@facebook.com | US |
| 3 | Instagram | New York | info@instagram.com | US |
| 4 | Dior | London | info@dior.com | UK |
Output: What was changed
| RowID | Name | Name_ERP | Name Check | City | City_ERP | City Check | Email | Email_ERP | Email Check | Country | Country_ERP | Country Check |
| 1 | Amazon | Amazon | TRUE | Paris | Paris | TRUE | info@amazon.com | info@amazon.com | TRUE | FR | FR | TRUE |
| 2 | FB | Facebook | FALSE | New York | New York | TRUE | info@facebook.com< | info@facebook.com | FALSE | US | US | TRUE |
| 3 | IG | Instagram | FALSE | NY | New York | FALSE | info@IG.com | info@instagram.com | FALSE | USA | US | FALSE |
| 4 | Dior | Dior | TRUE | London | London | TRUE | info@dior.com | info@dior.com | TRUE | UK | UK | TRUE |
I am looking for a dynamic solution as I have twenties of columns from each dataset
Please note RowID that can be used for RecordID.
Thanks for anyone who can help!
