Compare 2 data tables and select unique records in 2 data tables of all the columns in Data table 1 and matched record amount value in Data table 2

Hi All,

i am facing an issue while extracting 2 data table unique records

I have 2 Data tables like DT1 & DT2,

DT1 contains

Account Number Date
10001 12/12/2015
10002 12/12/2015
10003 15/06/2017
10005 15/06/2017

DT2
Account Number Amount
10001 35
10002 70

The output should be all the records of Data Table1 and matched amount of Data Table2

output should as followos

Account Number Date Amount
10001 12/12/2015 35
10002 12/12/2015 70
10003 15/06/2017
10005 15/06/2017

Like this:

Processusvierge.zip (8,0 Ko)

HI Anthony , can you please advise for the below issue

I have 3 Data tables like DT1 & DT2, DT3

DT1 contains

Account Number Date
10001 12/12/2015
10002 12/12/2015
10003 15/06/2017
10005 15/06/2017

DT2
Account Number Amount
10001 35
10002 70

DT3
Account Number Total Fee
10001 135
10003 79
The output should be as follow

output should as followos

Account Number Date Total Hold Total Fee
10001 12/12/2015 35 135
10002 12/12/2015 70
10003 15/06/2017 79
10005 15/06/2017

Just add another Full Join to the workflow I’ve provided for the 3rd table. Make sure to delete the new account number as I have in the workflow.

2 Likes

Thanks Anathony in the time being i was done that, Really trying to resolve from morning but you did my work simple,
Have a nice time

1 Like

Hi All,

I have 2 Data tables like DT1 & DT2,

DT1 contains

Account Number Date
10001 12/12/2015
10002 12/12/2015

DT2
Account Number Amount
10001