community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Flagging Changes in Two Near Identical Files

Atom

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!

Alteryx
Alteryx

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

Alteryx Certified Partner
Alteryx Certified Partner
Please try using my CReW delta macro.

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

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom

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!

Labels