Converting List<dataRow> to datatable

[alvin.c.apostol26 (Alvin)]

Hi UiPath,

Is there a easy way to convert List<DataRow> into a datatable variable?

Thanks!

[william.coulson (Will Coulson)]

Hi @alvin.c.apostol26,

You could iterate through your List and add the row to a DT using Add Data Row:

[Gokul001 (Gokul Balaji)]

Hi @alvin.c.apostol26

In the ArrayRow property of ‘Add Data Row’ activity, just supply the single string as an array,designated by curly braces {}

So it should be {item} in the ArrayRow property.

Have a look on the thread

How to convert list to datatable

I have three lists-Name, URL, Details. I want to convert these lists into a single datatable where each list is a column i.e. all the data in Name list will be in a single column ‘Name’ in datatable. Similarly for URL and Details. How would I do this?

Regards
Gokul

[Yoichi]

Hi,

FYI, the following will also work if the each items are from single datatable.

newDt = listDr.Select(Function(dr) dr.Table.Clone.LoadDataRow(dr.ItemArray,False)).CopyToDataTable

Regards,