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

Help
1

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
DataTable11576×792 152 KB

DataTable2
DataTable2
DataTable2860×200 18.7 KB

Regards Tomas

2

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
3

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

4

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