Compare 2 excel sheets

KNIME Analytics Platform
1

Hi,

I have 2 spreadsheets with the same amount of columns and headers. The amount of rows may vary.

Spreadsheet 1 will be the current’s month data set.

Spreadsheet 2 will be the previous month’s data set.

I need to compare these 2 spreadsheets with the output being :

  • what was added to the current month’s spreadsheet
  • what was removed from the spreadsheet
  • any change in role title

Table

Column A Column B Column C
Name ID Role

I understand I could perhaps use a joiner node but require help.

I am new to Knime so please be kind.

Thanks

2

You might want to have a look at the table difference node
br

2 Likes
3

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