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.
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.