Why are there several load statements with different field names pointing to the same table name

[julioarriaga]

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.

[felipedl · Accepted solution]

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.

[julioarriaga]

Thank you for your clear explanation!