How select on column in datatable and assign it to datarow array

[Susana (Susana González Cacheiro)]

Hello @moha_attia,

Hope this could help you, the following link os for a similar problem:

How insert whole column into one row with Pipe delimiter? Have two DataTables

Hi I need help Have two separate DataTables: DataTables1 contains one column with 3 to 9 URL`s, DataTables2 contains several columns and one of them is named “URL” Want insert into one row with Pipe delimiter whole rows of DataTables1 in to DataTables2 column named “URL” DataTable1 [DataTable1] DataTable2 [DataTable2] Regards Tomas

You can use something similar to ExtractDataTable.AsEnumerable.Select(Function(row) row(“City”).ToString)

Best regards,
Susana