O read the column from the pivot table, convert it to a string

Hello, everyone!
I have a data table d1 (in Excel file) that contains a sheet pivot1 with column A.

I need to read column A from the pivot1, convert it to a string in order to use it further.
Please, help me how to do it)

Hi @yulya

Please try this,

Read the data from excel using read range activity and store it in the datatable , variable name - dt

string.join(",",dt.asenumerable.select(function(d) d(0).tostring).toarray)


Thank you!

1 Like

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