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