topic Re: Simple order by question in QlikView

Simple order by question

Tue, 07 Feb 2012 16:10:29 GMT

Hi all.. I employed a order by function but I discovered that never worked. My syntax is:

History:

LOAD
user_id,
     bug_id,
     date_modified,
     prioridad,
     reabierto
FROM

(qvd);

Concatenate

LOAD

     user_id,
     bug_id,
     date_modified,
     prioridad,
     reabierto
FROM

(qvd);

Store History into ;

LOAD
     bug_id,
     user_id,
     date_modified,
     prioridad,
     reabierto
Resident Historial
order by bug_id , date_modified, prioridad;

Store History into ;

drop table History;

What could the problem be?

Thank.

Ivan.

Simple order by question

Tue, 07 Feb 2012 16:14:56 GMT

Sorry.. in Resident i employed History. thank!.

Ivan

Simple order by question

Jason_Michaelides — Tue, 07 Feb 2012 17:33:22 GMT

I think your issue is that the RESIDENT load is concatenating to the main table. Try changing your last script section to:

NoConcatenate

LOAD

bug_id,

user_id,

date_modified,

prioridad,

reabierto

Resident History

order by bug_id , date_modified, prioridad;

Store History into ;

drop table History;

Also, I don't know why you are storing to the same QVD file twice. Remove the first STORE command?

Hope this helps,

Jason

Re: Simple order by question

Tue, 07 Feb 2012 18:05:00 GMT

Hi, thank very much Jason, i remove the first store, it was a mistake to copy and paste. i change my script but also it doesnt work.

My new script:

Historial:

LOAD
user_id,
     bug_id,
     date_modified,
     prioridad,
     reabierto
FROM

(qvd);

Concatenate

LOAD user_id,
     bug_id,
     date_modified,
     prioridad,
     reabierto
FROM

(qvd);

NoConcatenate

LOAD
bug_id,
user_id,
      date_modified,
     prioridad,
     reabierto
Resident History
order by bug_id ,date_modified, prioridad;

Store Historial into ;

Please take a look at the qvd.

Thanks in advance.

Ivan.

Re: Simple order by question

Tue, 07 Feb 2012 18:10:30 GMT

I need only order by: first bug_id, second date_modified and third prioridad.

Thanks!.

Ivan.

Re: Simple order by question

Jason_Michaelides — Wed, 08 Feb 2012 08:50:24 GMT

I think you need to declare a name for the second table load, and don't forget to drop the first. So:

Historial_temp:

LOAD
user_id,
     bug_id,
     date_modified,
     prioridad,
     reabierto
FROM

(qvd);

Concatenate (Historial_temp)

LOAD user_id,
     bug_id,
     date_modified,
     prioridad,
     reabierto
FROM

(qvd);

Historial:
NoConcatenate

LOAD
bug_id,
user_id,
      date_modified,
     prioridad,
     reabierto
Resident History
order by bug_id ,date_modified, prioridad;

Store Historial into ;

DROP TABLE Historial_temp;

Give that a go.

Jason

Simple order by question

Wed, 08 Feb 2012 19:08:47 GMT

Jason, it works!.

Thank you very much.

Regards.

Ivan.

Re: Simple order by question

Jason_Michaelides — Wed, 08 Feb 2012 19:49:23 GMT

Coolio. You're welcome.