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

[#2]

what attachments.....?

[rajeshvaswani77]

Can you please attach an example?

thanks,

Rajesh Vaswani

[martin_dideriks]

First question: Why do you want to do a resident load of a table?

Though I have not tried a solution myself, I will guess it should work, if you rename your fields in the resident load.

The reason, that you see this behaviour, is that you have already loaded the fields NO, NAME,MARKS into the datamodel in TAB1. When you load the same tables in ABC1, the fields will be sorted just as in TAB1.

Ie. If you load a table like this:

LOAD * INLINE [

FieldA

B

C

A

];

The following data loaded into QV, will be sorted just like FieldA (providing FieldA) exists in that table.

[its_anandrjs]

Try this way and make this settings in the table box remove all sort settings in the properties and use only load order after order by for all fields and also try to load like in this sequence Name,No,Marks.

TAB1:

LOAD

      NAME,

      NO,

      MARKS

FROM

TRIAL.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

ABC1:

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

DROP TABLE TAB1;

Regards

Anand