How to append row in datatable single line

I have to append rows in datatable in single line
For example
Banglades
Chennai
Hyderabad
Result should be :bangladesh;Chennai;Hyderbad

Hi Sruthesanju,

You can loop through table and get row value as string added to list.
Than you can. String.Join(“,”, yourList)

Hi,

Can you try to use AddDataRow activity with the following settings?

{String.Join(";",dt.AsEnumerable.Select(Function(r) r(0).ToString))}

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.