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


DataTable2

Regards Tomas

Hi @kalianasu,

Hope this could help you.

One solution could be using the following code to get a list of the values stored in DataTable1:

String.Join(",",DataTables1.AsEnumerable.Select(Function(row) row(0).ToString).ToArray())

Here is an example: Sequence_99901.xaml (9.7 KB)

Best regards,
Susana

3 Likes

Thanks @Susana, it worked! I appreciate the help!

You are welcome @kalianasu, glad to help you :blush: