Converting datatable to datarow?

Help
,
2

Since a DataTable usually has multiple rows, it’s a bit weird to fit everything into a single row…

In any case, it seems you’re trying to iterate the rows of ExtractDataTable3 and, using the Add Data Row activity, add each row to another DataTable using datatable.select().
There are two problems with that:

  1. datatable.select() will give you an array of DataRow, but you already have it from using the For Each Row activity.
  2. Even if you pass just row to the Add Data Row activity, it’ll give you an error, because that row belongs to another table (ExtractDataTable3).

One possible solution is to pass row.ItemArray to the ArrayRow property of the Add Data Row activity: TransferingRows.zip (2.6 KB)

Let us know if you’re trying to do something different than this! If so, please provide more details. :+1:

4 Likes