How to get all the row values to one cell when creating a table

Hi ,
i need to get all the values in to one cell
Capture

Hi @Tharusha_Fernando

Read the excel using read range activity and store it in datatable (variable name is dtTable)

Then in assign ,

strText = string.join(",",dtTable.asenumerable.select(function (d) d(“product”).tostring).toarray)

StrText - string

After that use write cell and Pass the strtext and cell address in it

Thanks

1 Like

Thank you @prasath_S

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