Compare columns in two separate Excel files

Please I would love to compare columns of two separate excel files and be able to display both values that match on a separate column and the values that don’t match in two different columns.
For example, compare a list of employees identification numbers from a monthly report and tell the employees that added to the list of employees and those who left and those who remained

Hi @chefor99 , the general idea would be to load the 2 files separately (1 excel reader each) which will give you 2 data tables, then use the joiner (Labs) node to join the 2 tables.

This node has 3 outputs:

  • All matches
  • Exist only in the first table
  • Exist only in the second table

Here’s a demo:

Without any concrete data, I can only give you the general idea.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.