Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jesstungleumi
New Contributor III

Preceding load for concatenate (no resident)

Hello, I am looking for "preceding load" methodology to force concatenation between two tables of different fields, and then calculate based on the concatenated table. I know how to do it in resident and drop table, and I want to try preceding load, imagining it would be faster and would use less memory. But with the script below, it only populates [PL MARKER] for the first portion. How to do preceding load correctly?? Thanks.


PRECLOAD:
LOAD *,
'PL'
as [PL MARKER];


FIRST:
LOAD * INLINE
[Customer, Account, Balance, ExtraFieldJ
A,A1,10,J
A,A2,20,J
A,A3,30,J
B,B1,100,J
B,B2,200,J
B,B3,300,J]
;
Concatenate
LOAD * INLINE
[Customer, Account, Balance, ExtraFieldS
C,C1,10,S
C,C2,20,S
C,C3,30,S
D,D1,100,S
D,D2,200,S
D,D3,300,S]
;


Customer

Account

Balance

ExtraFieldJ

PL MARKER

ExtraFieldS

A

A1

10

J

PL

A

A2

20

J

PL

A

A3

30

J

PL

B

B1

100

J

PL

B

B2

200

J

PL

B

B3

300

J

PL

C

C1

10

S

C

C2

20

S

C

C3

30

S

D

D1

100

S

D

D2

200

S

D

D3

300

S

2 Replies
hector_munoz_in
Valued Contributor

Re: Preceding load for concatenate (no resident)

Hi Jessica,

Do the following:

PRECLOAD:

LOAD *,

'PL' as [PL MARKER];

LOAD * INLINE

[Customer, Account, Balance, ExtraFieldJ

A,A1,10,J

A,A2,20,J

A,A3,30,J

B,B1,100,J

B,B2,200,J

B,B3,300,J];

Concatenate (PRECLOAD)

LOAD *,

'PL' as [PL MARKER];

LOAD * INLINE

[Customer, Account, Balance, ExtraFieldS

C,C1,10,S

C,C2,20,S

C,C3,30,S

D,D1,100,S

D,D2,200,S

D,D3,300,S];

Regards,
H

maulajatt90
New Contributor II

Re: Preceding load for concatenate (no resident)

Hi Jessica,

Regarding your question, the Preceding Load will only work for the related table (Table 1). Qlikview loads data in the script's sequence order, it will process data in the following sequence in your case:

  1. Load Table 1
  2. Preceding load of Table 1
  3. Load Table 2
  4. Concatenate TABLE 1 with TABLE 2.

Depending on your requirements, if you just have to add only one hard coded flag ('PL' as [PL MARKER];) then I would suggest Hector Muñoz approach is perfect, but there would be a duplication of code if you have more fields and in case if you have to derive calculated fields based on the concatenated table then you must use the approach you have mentioned "RESIDENT LOAD and DROP TABLE".

Best regards,
JSI

Community Browser