Copy column and its value from one datatable to another

Help
, , ,
1

Hi, i have a predefined datatable (dt_new), and i want to copy specific column from another datatable (dt) to specific column in my predefined datatable.
For example this is my dt
image
and copy specific column by some condition to the dt_new, for example the dt_new will look like this:
image
How can i achieve this ?

2

Hi @RobertoEwaldo,

There is an activity Join data table, which will fulfill your requirement.

Thanks

3

hi @Karun,
Can you show me how to use it for my case ?

Thanks

4

Hi @RobertoEwaldo,

For this read your sheet to a datatable say DT now for getting a specific column write the below expression

DT.defaultview.totable("ColumnNameOnlyWanted",False)

Now use a write range and write this DT to another sheet at the Specific position where you want it.

Cheers!