Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Korto2024
Contributor III
Contributor III

Two Load in the same load

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

Labels (3)
1 Solution

Accepted Solutions
qv_testing
Specialist II
Specialist II

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

View solution in original post

4 Replies
qv_testing
Specialist II
Specialist II

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
Specialist
Specialist

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

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
steeefan
Luminary
Luminary

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
Contributor III
Contributor III
Author

Thanks all