Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Thank you in advance for your help. I'm a rookie in QlikView's syntax and I encountered a code that looks like the Image 1 and 2:
a) Several load statements;
b) with the * indicating to load all the fields, plus the calculating one;
c) with each load statement different fields are loaded
d) a single From at the end.
I can't get my head around the logic of this code.
I don't understand because it is not concating the information. My best guess is: is it doing some sort of resident load from the previous loads?
Kind regards.
Hi Andrés,
This is called precedent Load, there's a good article about it here Preceding Load
Simply put, it's the action to use the previously loaded fields into another calculation without having to load a second table.
E.g:
Table1:
Load
A,
B
From [whatever];
Table2:
Load
left(A,1) & right(B,2) as Key
Resident Table1;
Can be translated to
Table1:
Load
left(A,1) & right(B,2) as Key;
Load
A,
B
From [whatever];
The bolded part is the preceding load statement and I only had to use one table to do what I wanted and it is as you stated, a type of resident load onto the same table from the previous loads.
Felipe.
Hi Andrés,
This is called precedent Load, there's a good article about it here Preceding Load
Simply put, it's the action to use the previously loaded fields into another calculation without having to load a second table.
E.g:
Table1:
Load
A,
B
From [whatever];
Table2:
Load
left(A,1) & right(B,2) as Key
Resident Table1;
Can be translated to
Table1:
Load
left(A,1) & right(B,2) as Key;
Load
A,
B
From [whatever];
The bolded part is the preceding load statement and I only had to use one table to do what I wanted and it is as you stated, a type of resident load onto the same table from the previous loads.
Felipe.
Thank you for your clear explanation!