Convert column values datatype into string

[anjana.k]

I have datatable having one column which has 5 values(One value having data type double. another value having type string). How do I convert the whole values into the same datatype as string?

[Gokul001 (Gokul Balaji)]

Hi @anjana.k

Check out this thread

Convert data column to string

Hi, I am having a datatable with two columns in string format. It can have any random data as below. |Column1|Column2| |Mercury | Venus| |Neptune | Mars | |Jupiter|Saturn| |Uranus|Earth| My flow will receive an int parameter and I have to concatenate those many rows of column 2. Example1 : If flow receives 2 as parameter, then output would be “Venus,Mars” Example2: If flow receives 4 as parameter, then output would be “Venus,Mars,Saturn,Earth” It can be done using For loop, but wan…

How to get the values of a data column to a string

How to get the values of a data column to a string. Column1 Column2 ab er cd er ef er I want the the values of the column ‘Column1’, So that my output looks like “ab,cd,ef” Thanks in advance.

Regards
Gokul

[supermanPunch (Arpan)]

@anjana.k

I have datatable having one column which has 5 values(One value having data type double. another value having type string). How do I convert the whole values into the same datatype as string?

Hi @anjana.k ,

Maybe a revision is needed on the requirement details. A Datatable’s column will be of a Single Datatype (Mostly Object type if read from Excel). We need to understand if we need to convert the column in Excel into the Text/String format or you would need to change the column type of a Data Column in Datatable alone.

Also, Let us know why it is required for more understanding and clarity of the situation.

If Excel Column Type Change is the requirement, you could check with Format Cells Activity and Specify the range for the Conversion to Text format.