Sorting

[brindlogcool]

Hi,

I am trying to sort the text field (Full Name ) in the load Script as ascending order. but it is not working.

Anyone has faced the similar issue or is there anything i am missing.

I am able to sort the field in the list box using the Text option but not at the load script.

[kaushiknsolanki]

Hi,

     As far as i know, order by works with resident load not with load statement.

     So try like this.

     Data:

     Load * inline [

     Field1

     A

     C

     B

     ];

     Data1:

     Load Field1 as Field2 resident Data order by Field1 asc;

Regards,

Kaushik Solanki

[#3]

Hi  brindlogcool ,

You can use <TableName> Order By <ColumnName> in Load script itself and in the Properties Sort Tab, try sort by Load Order  and select the option Original.

Thanks,

Selva

[sushil353]

try to check your sorting setting in qlikview.. set it to load order...

HTH

Sushil

[brindlogcool]

Thanks for all you replies.

I did used the order by and set the load order in the list box still it is not working. I am facing the issue for the first time. For my previous project it is working fine.

It was a concatenated name first name and last name (ex Amy,Jackson) and even i replaced it ass Amy Jackson still it is not working. I am doing the sorting in the resident table.

[brindlogcool]

Text sorting is not working in the Load script. Any one had faced the similar issue?