topic Re: LOAD Statement in QlikView

LOAD Statement

Anonymous — Tue, 15 Jul 2014 13:35:16 GMT

Hi,

I came across this code in a dashboard and can someone explain how it work. Why is there 2 load statements and only 1 from statement ? What is the source of the first LOAD ?

SLA:

LOAD

state as sla_state,

priority as sla_priority;

Directory;

LOAD

state,

priority

FROM [task.qvd] (qvd);

Re: LOAD Statement

PradeepReddy — Tue, 15 Jul 2014 13:44:43 GMT

Instead of code you mentioned, we can write in single Load statement...

SLA:

LOAD

state as sla_state,

priority as sla_priority

FROM [task.qvd] (qvd);

Re: LOAD Statement

kji — Tue, 15 Jul 2014 13:45:24 GMT

A load preceding another load (or select) will take the second part as input.

Re: LOAD Statement

its_anandrjs — Tue, 15 Jul 2014 13:55:17 GMT

Its a preceding load statement and by first statement state, priority fields are get renamed to new name. You can directly renamed it

SLA:

LOAD

state as sla_state,

priority as sla_priority

FROM [task.qvd] (qvd);

SLA:

LOAD

state,

state as sla_state,

priority,

priority as sla_priority

FROM [task.qvd] (qvd);

Re: LOAD Statement

hic — Tue, 15 Jul 2014 14:20:18 GMT

The Preceding load is explained in this article: Preceding Load.

HIC

Re: LOAD Statement

Anonymous — Tue, 15 Jul 2014 23:23:43 GMT

Thanks everyone for the quick answer.

So in my example, the final SLA table have sla_status and sla_priority. Is the inner table still available or is it discarded ?

Re: LOAD Statement

Anonymous — Tue, 15 Jul 2014 23:28:37 GMT

Also can you achieve what preceding load does with resident load ?

TempTable:

Load

status,

priority;

from ...

Load

status as sla_status,

priority as sla_priority;

resident TempTable;

Re: LOAD Statement

hic — Wed, 16 Jul 2014 07:09:07 GMT

There is no "inner table". There is an inner Load and an outer Load that are executed together, and result in one table only. So, the outermost Load defines the content of this table.

HIC

Re: LOAD Statement

Anonymous — Wed, 16 Jul 2014 15:48:28 GMT

Understood. Thanks.

Re: LOAD Statement

Anonymous — Wed, 16 Jul 2014 15:50:24 GMT

I read in another thread is Preceding Load is more efficient than Resident load.