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

[yulya (Yulya R)]

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)

[prasath_S]

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)

Thanks

[yulya (Yulya R)]

Thank you!