We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

compare two excel containing multiple sheets and ~50 columns

mohd_shakeel
5 - Atom

I have two excel both files are similar, both have same count of sheets and columns on each sheets. 

Three tabs and more than 50 columns in each tab.

columns contains 'Any value' (text/decimal)

there might be chances that few of the cells/fields may vary in one file. 

I am not able to find a way how to compare both the files and find out the deviation/difference(s) between two file.

1 REPLY 1
drew9
8 - Asteroid

Hi @mohd_shakeel ,

 

I actually built an analytic app for this exact purpose. See attached. If your files have a primary key, I'd recommend using that as long as there are not duplicate keys. Record position will work as well but this is assuming that the order of the rows has stayed consistent. Hope this helps!