topic Re: ORDER BY in QlikView

ORDER BY

Anonymous — Sun, 13 Apr 2014 07:12:53 GMT

greetings

I have a QVD file i need to order the fields names by ABC

any simple way to do this???

Thanks

Re: ORDER BY

MK_QSL — Sun, 13 Apr 2014 07:53:00 GMT

Load * From [QVDName.qvd]

(qvd)

Order By ABC;

if you want in desc order

Order By ABC Desc;

Re: ORDER BY

maxgro — Sun, 13 Apr 2014 09:22:43 GMT

this is an example, adapt to your qvd

Directory;

Tmp:

LOAD Name, Address

FROM Name.qvd (qvd)

//order by Name this doesn't work

;

Final:

NoConcatenate Load *

resident Tmp

order by Name;

drop table Tmp;

from online help

order by is a clause used for sorting the records of a resident table before they are processed by the load statement. The resident table can be sorted by one or more fields in ascending or descending order. The sorting is made primarily by numeric value and secondarily by national ASCII value. This clause may only be used when the data source is a resident table. The ordering fields specify which fields the resident table is sorted by. The field can be specified by its name or by its number in the resident table (the first field is number 1).

Re: ORDER BY

Anonymous — Sun, 13 Apr 2014 10:49:37 GMT

i don't need the sort on the records but on the table fields

a	b	d	c
adam	brother	boy	23

i need the QVD file to be

a	b	c	d
adam	brother	23	boy

first a - b - c- d- and not a-b-d-c-

Re: ORDER BY

swuehl — Sun, 13 Apr 2014 13:04:27 GMT

Why do you need to sort the field names?

In general, you can just state the order in your load, instead of using the star symbol *:

LOAD

FROM YourFile.qvd (qvd);

Re: ORDER BY

Anonymous — Mon, 14 Apr 2014 05:47:56 GMT

i know but the problem is i have about 30 tables and each table has more that 150 fields so arranging them manually wont work

Re: ORDER BY

tresB — Mon, 14 Apr 2014 05:50:32 GMT

Extract them in excel and sort there; copy-paste the sorted fields back in qv script.

Re: ORDER BY

er_mohit — Mon, 14 Apr 2014 05:54:27 GMT

Temp:

load * from qvd;

noconcatenate

Final:

load * resident Temp

order by fieldname;

drop table Temp;

Re: ORDER BY

Anonymous — Mon, 14 Apr 2014 05:56:13 GMT

i need the order by on the fields not the field values