Column Compare from 2 files

[Pragadeshgp]

I have two different files with the Same Set of columns, need a node or workflow to compare all the columns.

First File:

Second File:

Rank	Name	Aug	Sep	Oct	Nov	Dec	Jan
1	A	1	2	3	4	5	6
2	B	2	3	4	5	6	7

Appreciate if get a help to compare two files

Thanks

[elsamuel]

What does “compare all the columns” and “compare two files” mean exactly?
What is your desired output?

[Pragadeshgp]

(First File: Columns Aug,Sep,Oct,Nov,Dec,Jan) - (Second File: Columns Aug,Sep,Oct,Nov,Dec,Jan)

First File:
Rank	Name	Aug	Sep	Oct	Nov	Dec	Jan
1	A	5	6	7	8	9	10
2	B	6	7	8	9	10	11
Second File:
Rank	Name	Aug	Sep	Oct	Nov	Dec	Jan
1	A	1	2	3	4	5	6
2	B	2	3	4	5	6	7
OutPut:
Rank	Name	Aug	Sep	Oct	Nov	Dec	Jan
1	A	4	4	4	4	4	4
2	B	4	4	4	4	4	4

[elsamuel]

This workflow seems to work after some tweaks: Substraction of two tables - #3 by ferry.abt

Give it a shot.

[Pragadeshgp]

ok
My scenario is for the 2 Files but I will verify link which you have given
Thanks @elsamuel for continuous help

[Pragadeshgp]

Substraction of two tables - #3 by ferry.abt

Unable to find KNWF file in the zip. Please verify and confirm

[elsamuel]

There is no knwf file. Download the zip file, then in KNIME go to File>Import KNIME Workflow and select the zip file you downloaded.

[Mark_Ortmann]

Maybe this node helps? Table Difference Finder – KNIME Hub

Best,
Mark

[Pragadeshgp]

Thanks Mark
Will check it

[Pragadeshgp]

Getting this Error message when using the Excel File in the node ‘Table Difference Finder’

ERROR Excel Writer 0:14 Execute failed: Unsupported column type ‘DataCell’. Please remove corresponding column(s) from the input table.