Hello!
How do i convert a List<List> in a datatable with 12 columns?
Hello!
How do i convert a List<List> in a datatable with 12 columns?
in case of the list structure is consistent and each outer list item has a list with 12 items.
Give a try on:
Prepare your empty Datatable by modelling the 12 cols with the build datatable activity - dtResult
then use an Assign activity
LHS: dtResult
RHS:
(From x in YourListOfListVar
let ra = x.toArray
Select r=dtResult.Rows.Add(ra)).CopyToDataTable