Hi, I have two tables with same and different values in column a. I need to write values from dt2.
Dt1:
Dt2:
Final dt:
Hi, I have two tables with same and different values in column a. I need to write values from dt2.
Dt1:
Dt2:
Final dt:
Hi @markosc ,
Kindly refer below link, use join data table activity to join the table, you can provide the conditions in join wizard.
Regards,
Arivu
You can use Join Datatable activity where you can give the condition as “a” = “a”
Hope this may help you
Thanks
No because with join the result is like this:
You can check with different join Types, Try with Left and let us know
Hope this may help you
Thanks
Use a Full Join datatype
Your case is a typical Join scenario. But only use = as operator
About Join types have a look here:
After joining the datata (result: dtJoin DataTable) just remove the unneeded Columns added by the Join activity by
Rename later b_1 ColName to c by
YourDataTableVar.Columns(“b_1”).ColumnName = “c”
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.