Flagging Changes in Two Near Identical Files

[Yo_Rosco]

Hello,

I want to create an application where users can input two Excel files, and have any differences between the two files flagged. The files would be the same exact outputs from a different workflow I already produced, so I simply need a way that users can see what, if anything, changed between the two files (e.g. the original workflow was ran yesterday, I run it again today, and the user can see if any of the data in today's document is different or changed compared to yesterday).

I was thinking a simple Join may work, but there are so many fields in the documents that they wouldn't know exactly which field or row had been altered! Any suggestions? Thank you!

[JordanB]

Hi @Yo_Rosco 

You want to check out this article https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Comparing-Data-from-Two-Datasets/ta-p/9414

Tony uses a record ID, Transpose and Join to ensure each row & column are checked for differences, despite the number of fields

best,

Jordan

[MarqueeCrew · Accepted solution]

Please try using my CReW delta macro.

https://gallery.alteryx.com/#!app/CReW-Delta--Alpha-/5b41141b826fd3116445fee8

Cheers,

Mark

[Yo_Rosco]

Thank you very much, this is extremely helpful! 

[Angelesayga]

Hi Mark - I was looking at your Macro, but have a question for you. The fields in both files have to be named the same, right? Thank you so much!