How to join the data tables and create the final report

Help Studio
, ,
1

Hi Team,

I have two data tables
dt1:

ID Test
101 97
102 45
103 30

Dt2:

ID Test
101 98
105 67
109 29

Final result should be:

ID Test1 _dt1 Test1_dt2
101 97 98
102 45 0
103 30 0
105 0 67
109 0 29

Could someone help me on this quickly.

2

Hi @Srini_M ,

Here is the code to achieve your requirement.

Let me know if you need any help on the same.

Sequence.xaml (11.6 KB)
dt.xlsx (12.0 KB)

Regards,
Ashutosh Gupta

3

we can use the Join DataTable activity for this - Join Type: Full
from the resulting Join DataTable we can extract the needed columns and also rename the datacolumn name if needed