Hi, I need help on Column A,B and D at ‘Example’ sheet
paste those column at last row of Column A,C and E at ‘Destination’ sheet.
Anyway on how to do this? Thanks so much
Example1.xlsx (12.7 KB)
Hi, I need help on Column A,B and D at ‘Example’ sheet
paste those column at last row of Column A,C and E at ‘Destination’ sheet.
Anyway on how to do this? Thanks so much
Example1.xlsx (12.7 KB)
Hi
Hope the below steps would help you resolve this
Use a read range activity and get the datatable as output named dt1 of first sheet
Then use another read range activity and get the output as dt2
Now use a FOR EACH ROW activity and pass dt1 as input and inside the loop use a add Datarow activity with ArrayRow mentioned as
{CurrentRow(“Item”).ToString, String.Empty, CurrentRow(“Tax Rate”).ToString, String.Empty, CurrentRow(“Value c”).ToString}
And datatable mentioned as dt2
Instead of string.Empty you can also keep any string value if you want
Cheers @mashy2
hi, in step 2, read range from another sheet ‘Destination’?
Then how i can write range in last row?
Yes that’s right
Add Datarow activity will usually write in the last row of the datatable
Cheers @mashy2
hi, i have tried but somehow it also add original dt2 value, is there anyway to prevent this
thanks, i got it already
btw, is there any way without using for each row? cause if got many data, feel kinda slow need to go trough 1 by 1
its okay, tqvm
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.