I have 2 files with the same header information and want to compare the data from both the files for all the attributes which are almost 100 columns. Can someone please suggest and help with the logic?
Hey @shahamit1404,
When you want to compare 100's of columns always use the transpose tool. This will but all the columns information onto two columns which makes everything very easy to compare using a join tool. The stuff which joins matches and the left and right output will show what is different. You can use the crosstab to reconvert back the data to the original format:
This solution uses the transpose and cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done
Any questions or issues please ask :)
HTH!
Ira