Two Load in the same load

[Korto2024]

Hi ,

can any one explain me this script please and explane the difference between the two load:

LOAD
Col1,
Col2
;
LOAD
col1

FROM [tab.QVD] (qvd);

Thanks

[qv_testing · Accepted solution]

This is called a Preceding Load 
QlikView Preceding load is a load type in which we use a load statement, which takes the columns of another load statement present in the same script. 

Preceding LOAD | QlikView Help

[MatheusC]

Hi, @Korto2024 
I believe you are referring to the Preceding load, see the documentation qlik help below to understand its use:

https://help.qlik.com/pt-BR/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/load-data-...

https://help.qlik.com/pt-BR/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/precedi....

Regarts,
Matheus

[steeefan]

I'd like to point out that your code would not work because you are using Col2 in the precedig LOAD but not in the one getting data from the QVD file. Preceding LOAD will only work on fields that were loaded before that specific LOAD statement.

[Korto2024]

Thanks all