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

[wuzgood]

Hi All,

I’d like to ask for your assistance in creating a workflow that compares two Excel files and finds missing and mismatched entries.

I already have a workflow in place of using Joiner to find missing entries, but I also need the mismatches. I tried using the rule engine and manually configuring which columns to check, and I’d like to improve it so that it’s more generic and reusable for other excel files I want to compare.

File 1 = Reference Table
File 2 = Transaction Table

Output 1 = Missing in Transaction Table (All missing entries based on Inventory ID)
Output 2 = Missing in Reference Table (All missing entries based on Inventory ID)
Output 3 = Mismatch Entries (All entries that are present in Transaction Table but with different value in some of the columns)

[bruno29a]

Hi @wuzgood , you can do this via the Joiner node with the following settings.

[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…

[diego_rod_lop]

Hi @wuzgood thanks for your post

As @bruno29a mentioned, part of the job can be done with the Joiner node and setting the configuration as explained. In this way, you can generate Output 1 and 2.

Instead, to generate Output 3, you can use the Table Difference Finder node that compares the differences between the two tables.

In this link , you can find an example workflow using the data you provide. See a preview below

Hope it could be helpful to somehow,

BR.