Yes you can pass columns from one datatable to another datatable.
I have attached a sample workflow for you and a sample excel sheet.
- Sample excel sheet has 4 columns.
- I have created a table using build datatable activity which has 1 column.
- Now i have added the 4 columns of a datatable to 1 column of another datatable of build datatable.
- Now the resulted build datatable will have 5 columns.
So here one thing to be noted, we cannot use column property of Add data column activity we have to use column name property as we get the error the “column belongs to another datatable” when we use Column property
If you are inside for each, using column property you cannot add the columns to another table.
If you see the same thing happens in Add data row activity when you pass the row variable in Datarow property, you get the same error “this row belongs to another table”
Main.xaml (8.8 KB)
Book1 (1).xlsx (9.1 KB)