How to copy data from one data table to another?

I have two data table DT1 and DT2, I have to compare column 1 of dt1 with column 1 of dt2 and get matched rows column 10 value from dt1 to column 7 of dt2. How do i do that?

You can use two For Each Row, nesting.The first one is for dt1, and when process each row in dt1, you put for each row of dt2 in it.
roughly like
For each row1 in dt1:
For each row2 in dt2:
index=index+1(to record line number)
if(row1(“c1”).tostring)=row2(“c1”).tosring):
get row1 item col10
write cell col7+index.tostring

What i have done is this
image

because i dnt want to use write cell it takes much time,but now its showing some error

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.