Attribute Changes Summary Report For specific Common IDs

[skotian1289]

Hello All,

I need your assistance as I am pretty new with alteryx, I am reconciling multiple columns between 2 similar files but for different dates. The idea is to identify which attributes have changed . My current workflow is able to join both files based on "User IDs" bring all columns from both files together and then reconcile the data and throw a "TRUE" and "FALSE" results. However I want to prepare a final summary report to show which User IDs have changed and which are the list of attributes (FALSE Columns) for specific user ids have changed.

I am attaching a sample file which shows my current tool output and Expected final output for reference.

Any suggestions or assistance in resolving this would be really helpful.

Thanks

[T_Willins · Accepted solution]

Hi @skotian1289,

Attached takes your current output to your desired result.

[Qiu · Accepted solution]

@skotian1289 
Hope this is what you need.

[Qiu]

@T_Willins 

Did not occure to me that we can change the Field name😁