Get Collection column as number

[RajsudhapriyaCN]

Hi all,

I have two queries 

1.In a collection I have to convert the column type from Text to number.

2.In a collection I have to sort the column values from large to small . i have used the function sort collection but i was not filtering the values since the column was in text format.

Could anyone help how to sort the collection chance type into number 

Regards,

Rajsudhapriya

------------------------------
Rajsudhapriya CN
------------------------------

[Athiban_Mahamathi · Accepted solution]

Hello,

Please try the below.

1.In a collection I have to convert the column type from Text to number.

  Create a cloned version of your input collection and change the column data type as number for the required field. Use copy rows action from the collection manipulation utility to copy the input collection to your output collection. This will help you to cast the required field from text to number.

  Input collection: 

 

Output Collection:

Flow:

2.In a collection I have to sort the column values from large to small . i have used the function sort collection but i was not filtering the values since the column was in text format.

Try the above said approach to cast your collection field data type and then try the sort function.

------------------------------
Athiban Mahamathi ,
Technical Consultant
------------------------------

[RajsudhapriyaCN]

Thankyou @Athiban Mahamathi  That worked

------------------------------
Rajsudhapriya CN
------------------------------