I’ve two data tabls one with name, second data table is with name and some body. I want to merge these two data tables when ever the name of dt1 matches dt2. if the name in dt2 is not there in dt1 then a new row of that name to be created. I have tried using full join table but got error like
Demo workupdation.xaml (13.7 KB) attached my workflow
Did MERGE DATATABLE ACTIVITY helped us in this
Ensure that both the datatable has same number of columns, same Order of columns and same datatype of columns
Cheers @Chaitanya_podilapu
1 Like
both data tables didnt have same number of columns, using merge data activity i’m getting empty data table
XAML: Demo workupdation.xaml (15.3 KB) I’ve achieved it using joins but got another problem. my first datatable (dt) should store names, and second on stores (dt1) names and body. when i’m joining both, duplicate data also generating
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu