Hi Friends,
I need your help. How can we copy a particular column from one data table to another data table?
For Example:
Let’s assume that we have 2 data tables with names DT1 and DT2. I have to copy a column with the name say “Location” from DT1 to the column by the name “Area” in DT2. Can anyone help me with the same.
Hi @arivu96,
Nope ! That’s the one leading to this confusion. I have multiple columns in DT2 as well. So, is there any option to copy one specific column from DT1 to another specific column in Dt2.
Hi @arivu96,
So, you’re asking me to copy that particular column in DT 1 to a new data table. Later, copy that new data table to that particular column in DT2 right?
I thought of the same thing. I will try that and will let you know.
I would like to copy and paste values from one column of a data table to another column of another data table. Please have a look at the below Screenshot.
I would like to copy all the columns values from first table and paste it to the new Datatable (shown below).
For example : Name to Full name , Address to Area and Country to Country/City
I have taken column by column approach. please advise if its the best practice.
Use for each row activity and append the value into another table.
dt1(Name,Address,Country)
dt2(Full Name, Gender,Area,Salary,Country)
For each row (dt1) add data row activity
Properties DataTable : dt2 DataRow : {row("Name").ToString(),"",row("Address").ToString(),"",row("Country").ToString()}