Compare two table and find differences


#1

Dear all,

I’m looking for a solution how to compare two column from different Table and then appear new column.

Example
reference Table1
column1 | data Standards| date Table1
test1 | cc1 | 2018-06-04
test2 | cc2 | 2018-06-04
test3 | cc3 | 2018-06-04

Table2
column1 | data Standards_2| date table2
test1| cc1 | 2018-06-06
test2 | cc2 2nd edition | 2018-06-06
test3 | cc3 2nd edition | 2018-06-06

how can I compare two columns from two different tables

IF (date Table1 !=date table2 && data Standards_2!=data Standards )
!= (not equals) comparison
=> then RESULT create new table as new coulmn that has where exactly the different

Fianal Table
column1 | data Standards_2| date | Update
test1 | cc1 | 2018-06-06 | NO UPADATE
test3| cc2 2nd edition | 2018-06-06 | Updated
test3 | cc3 2nd edition | 2018-06-06 Updated

ELSE
Final Table still reference Table1
column1 | data Standards| date Table1
test1 | cc1 | 2018-06-04
test2 | cc2 | 2018-06-04
test3 | cc3 | 2018-06-04


#2

Hi @Mokrani -

What about something like this? Note that this workflow assumes you have two tables with aligned rows. If you don’t, you’d need to use the Joiner node, which would be marginally more complicated. The output is two tables similar to what you’ve laid out above.

TableComparsionRuleEngineRowFilter.knwf (17.3 KB)


#4

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