How to merge two columns with different names in different data tables as on

For example
dt1

Code value
111 xxx
222 yyy
333 zzz

dt2
GroupCode value
434 aaaa
565 bbb
767 cccc

I need out put data table

Code value
111 xxx
222 yyy
333 zzz
434 aaaa
565 bbb
767 cccc

I have used join but it is not giving it in single column
If any one have any idea please suggest

Thanks,
nikhil

Hey @nikhil.s

Check out this video: Adding Specific Columns From One Data Table To Other - YouTube

Cheers,
Parth

You can change column name in second table to be the same
assign “Code” to dt2.Columns(“GroupCode”).ColumnName
Then use Merge Data Table activity

if you want to prevent column name change in dt2, you can first call dt2.Copy(), it will create new DataTable with same schema, saving values from dt2
Or just rename column in dt2 back after Merge activity

Rename the DT columns so they’re the same, then merge.