Sorting Nvarchar datatype

[#1]

Hi All,

Please find the attched excel .I want to sort based on the hard disk size. Could you please help in getting the solution?

Thanks,

Rahul

[#2]

Try this:

Directory;

LOAD @1 as Capacity,

Num#(Replace(@1, 'GB', ''), '#.#', '.', ',') as NCapacity

FROM

HD.xls

(biff, no labels, table is [Sheet1$]);

and order by field NCapacity.

[Hugo_Sheng]

Are you looking to perform the sort in Expressor or QlikView?

There's a dedicated Sort operator in Expressor that allows you to specify the sort key(s) and then allows you to subsequently process the data accordingly.

[#4]

Opps! I think I didn't read the discussion group name and I thought I was in a QlikView discussion.

As Hugo says, you can use the Sort operator. I have created a Dataflow to test the solution:

[#5]

Qlikview

[#6]

Atatched QVW for reference.

test:

LOAD left(@1,len(@1)-1) as col1,@1 as col2 from c:\HD.XLS

(

biff, no labels, table is [Sheet1$])

(

Noconcatenate

test2:

load * resident test order by col1:

drop table test;

[Hugo_Sheng]

Moving this to the proper discussion area