Using Add Data Row but specify columns

[jon1302]

Hello,

I’d like to transfer rows of data from one data table to another. I am able to identify the rows but what is the best way to transfer them?

I’m currently using Add Data Row but unsure how i specify which columns to transfer?

Thanks

[GouthamVijay]

Hi @jon1302
If you are using Add Data Row, if you want particular column to copy from one datatable to another, use build data table before for loop and add the same column name to that.
Please refer the following program,
Main.xaml (9.0 KB)
new.xlsx (7.8 KB)

Thanks.
Goutham Vijay

[jon1302]

Thanks, how can i modify the input ArrayRow value to transfer more than 1 column?

[GouthamVijay]

Use
{row(0).ToString,row(1).ToString}

But follow the same structure in build datatable.

Thanks.

[jon1302]

Brilliant. Thank you