Problem for sorting based on two columns

bharatmajeti · Post by **bharatmajeti** » Thu Jun 11, 2009 1:23 am

Hi,
I want to sort my data based on two columns namely "snumber" and "sdigit".

I tried by giving the following options in sort specification

1) snumber, sdigit asc
2) snumber asc, sdigit asc
3) snumber asc [, sdigit asc]

but none of the above trails worked, and i am getting " Internal Error: sort specification error, " can anybody help me

ArndW · Post by **ArndW** » Thu Jun 11, 2009 1:29 am

Option (2) looks like the correct way to do it. What happens if you use just one sort key (try both columns separately); does it work without an error or do you also get an error?

nagarjuna · Post by **nagarjuna** » Thu Jun 11, 2009 6:13 am

Make sure that the column names you specified in the source is same as that of sort stage .

ray.wurlod · Post by **ray.wurlod** » Thu Jun 11, 2009 4:30 pm

Option 2 is a correct sort specification. provided that the input column names are correctly spelled and cased.