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!
Solved! Go to Solution.
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
Thank you very much, this is extremely helpful!
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!