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
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.