How to merge two data table?

[Kumar_Sahu_Sameer]

How to achieve the desired output ?

Name	ID
Sameer	101
Abhishek	102
Sagar	103
Raju	104
Sandhya	105
Deepika	106
Name	DOB
—	—
Sameer	13-12-1998
Abhishek	23-03-1989
Sagar	18 July,2001
Raju	04-02 1990
Sandhya	19.10.2002
Deepika	12.05.1996
desired output :

desired output :

Name	ID	DOB
Sameer	101	13-12-1998
Abhishek	102	23-03-1989
Sagar	103	18 July,2001
Raju	104	04-02 1990
Sandhya	105	19.10.2002
Deepika	106	12.05.1996

[lrtetala (Lakshman Reddy)]

Hi @Kumar_Sahu_Sameer

Try this

Input DT1:

InputDT2:

Output:

Cheers!!

[vrdabberu (Varunraj Dabberu)]

Hi @Kumar_Sahu_Sameer
Build DataTable:

Output: joinedData
Input1:

Output:dt1
Input2:

Output:dt2
Use Below query in assign acitivty:

joinedData= (From row1 In dt1.AsEnumerable()
                Join row2 In dt2.AsEnumerable()
                On row1("Name").ToString() Equals row2("Name").ToString()
                Select joinedData.LoadDataRow({row1("Name"), row1("ID"), row2("DOB")}, False)).CopyToDataTable()

Output:

Sequence16.xaml (10.0 KB)

Regards