Sorting data

rajeevm · Post by **rajeevm** » Mon Jan 14, 2013 8:23 pm

Hi All,

I would like to sort the input column on descending order but facing problem with it. My input data looks

Col1, Col2
A, 5
B, 10
C, 15
D,20
E,25
F,30
G,35
H,40
I,45
J,50

I used sort stage in descending order and in sequential mode.

and the output I have

J,50
A,5
I,45
H,40
G,35
F,30

How to sort the data if it have single digit.

I appreciate your help

Thanks
Raj

jwiles · Post by **jwiles** » Mon Jan 14, 2013 8:37 pm

Convert column 2 from a string to a numeric datatype, such as integer or decimal, before sorting.

Regards,

stuartjvnorton · Post by **stuartjvnorton** » Mon Jan 14, 2013 8:40 pm

Alright Ashton, you can come out now...

jwiles · Post by **jwiles** » Tue Jan 15, 2013 12:28 am

ya think?