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
What does “compare all the columns” and “compare two files” mean exactly?
What is your desired output?
(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 |
This workflow seems to work after some tweaks: Substraction of two tables - #3 by ferry.abt
Give it a shot.
ok
My scenario is for the 2 Files but I will verify link which you have given
Thanks @elsamuel for continuous help
Substraction of two tables - #3 by ferry.abt
Unable to find KNWF file in the zip. Please verify and confirm
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.
Thanks Mark
Will check it
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.
system
Closed
12
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.