DSXchange

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

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?

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

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