Compare 8 columns between 3 excels in Alteryx

kafka_u21

I have 2 excel files, each has 8 columns each with same headers. i need to compare the data between the 2 excels and get the difference between the 2. Is there any quick way to compare ? or should i be putting in 8 separate joins between the 2 source files and compare?  #new2Alteryx #stillearning #vlookup

Yoshiro_Fujimori

Hi @kafka_u21 ,

Here is one way of doing this.

The idea is to break down the table into Row No and Column No.

I hope this helps.

Workflow

CompareTables.yxmd