order by not working

[rahulhv1]

Hi gurus,

below is the simple code I am having

TAB1:

load NO, NAME,MARKS FROM D:\TRIAL.XLS (ooxml,embedded labels, table is Sheet1);

Noconcatenate

ABC1:

Load NO, NAME,MARKS  resident TAB1 Order by NAME;

drop table TAB1;

In result I found that Order by clause do not work. I have tried different combinations i.e. NO , NUM(NO) , NAME but it doesn't work.

Pls. suggest me the solution

[alexandros17]

It should work, could you please send the reult?

[marcus_malinow]

Try adding 'RowNo() as RowNumber' to your ABC1 load to confirm that it's not working.

You could also try t create a chart using your sorted dimension, and sort by Load Order.

If you still have an issue could you post some of the affected data?

[#4]

The order shoudl work fine, maybe try to specify the ordering you want

Order By NAME asc

for example

hope that helps

Joe

[alexandros17]

maybe there are leading or trailing charachters ... try with trim(NAME)

[rahulhv1]

how to attach document in reply?

[rajeshvaswani77]

Hi,

Did you drop tab1?

thanks,

Rajesh Vaswa

[#8]

Its working ... just check it out once

ABC1:
Load NO,Name,Marks,RecNo() as Count

Resident TAB1

Order by NO desc;    // order by asc either of them will work

[its_anandrjs]

Try this way also

It is working try to click on Ctrl + T and see the difference.

1. Once load without the order table and see Ctrl + T.

2. Then add the Order table and then see Ctrl + T

You seethere is order by try to load data in the table with sorted order

Or you can do by adding RecNo() as Rec or RowNo() as Rowid

NoConcatenate

ABC1:

LOAD NO,NAME,MARKS,RecNo() as Rec  Resident TAB1 Order BY NAME;

DROP TABLE TAB1;

Regards

Anand

[rahulhv1]

even this is not working. have u seen my qvw & xls file that I have attached?