2 Ienumerable to 1 Datatable

[KevinDS (Kevin Da Silva)]

I have some problem…
Im taking two columns from one excel with read column activity. The output is two Ienumerable variables with two different columns.
Now i want to put this two variables into a datatable together with “add data row” activity. But it doesnt work that way…

Somebody knows how to do it?

[Sat]

Hi @KevinDS,
Use For each Activity, inside the loop use Add data row. In the properties of Data row, provide array of item i.e. {item}, in ArrayRow field. Create a DataTable using Build DataTable activity. Assign the datatable variable from Build Data table activity to Data Table field of Add Data Row Activity.

Thank you!