Order By

[oliveira1903]

Hi guys,

I am new in Qlik. =]

I'm trying to use the order by but when I drop the table, everything is gone.

For example:

Table 1:

Load

Dado1,

Dado2

FROM

[.. \ .. \ Blabla\ QVD \ RH \ Tabela1.qvd] (QVD);

Table 2:

LOAD *

Resident Table1

Order By _______desc, _______ desc;

Drop Table Table 1;

I used this example (Can you use 'Order By' in a QVD Load?) but for me it didn´t work.

What am I doing wrong?

Thanks

[sunny_talwar]

You need to add NoConcatenate in your resident load because you are loading all your fields from the previous table. QlikView auto concatenates them and when you drop your first table, everything is gone

Table 1:

Load

Dado1,

Dado2

FROM

[.. \ .. \ Blabla\ QVD \ RH \ Tabela1.qvd] (QVD);

Table 2:

NoConcatenate

LOAD *

Resident Table1

Order By _______desc, _______ desc;

[swuehl]

You  need to use a NOCONCATENATE LOAD Prefix:

Table 1:

Load

Dado1,

Dado2

FROM

[.. \ .. \ Blabla\ QVD \ RH \ Tabela1.qvd] (QVD);

Table 2:

NOCONCATENATE

LOAD *

Resident Table1

Order By _______desc, _______ desc;

Drop Table Table 1;