Compare 2 Excel File with same columns but with possible missing entries and mismatch

[lelloba]

Possibly similar to this?

Compare multiple columns in a joined table

Hi. I would like to be able to loop through each column within two joined tables and compare the values in each row. For example, I have used the Joiner node to join the following two tables using Employee ID as the match. Table1 |Employee ID|First Name|Last Name|Person Type| |0001|Bugs|Bunny|Employee| |0002|Mickey|Mouse|Employee| |0003|Charlie|Brown|Ex-Employee| |0004|Pink|Panther|Employee| Table2 |Employee ID|First Name|Last Name|Person Type| |0001|Bugs|Bunny|Employee| |0002|Mickey…