topic Re: CASE 300 How to load multiple raw data using 1 load script. in QlikView

CASE 300 How to load multiple raw data using 1 load script.

paulyeo11 — Sat, 16 May 2020 05:50:34 GMT

Hi All

Below load script working fine :-

Directory;
LOAD COY,
'A' as SOURCE,
SALES
FROM
COY_A.xlsx
(ooxml, embedded labels, table is COY_A);

Concatenate

LOAD COY,
'B' as SOURCE,
SALES
FROM
COY_B.xlsx
(ooxml, embedded labels, table is COY_B);

I like to convert the below load script :-

For Each i in A,B
Directory;
LOAD COY,
'i' as SOURCE,
SALES
FROM
COY_A.xlsx
(ooxml, embedded labels, table is COY_i);
NEXT i;

I get error msg :-
Field not found - <COY>

Paul

Vegar — Sat, 16 May 2020 06:57:46 GMT

I haven't access to QlikView today, but by the look of your post sample I would try these adjustments.

For Each i in 'A','B'

LOAD COY,

'$(i)' as SOURCE,

SALES

FROM

COY_$(i).xlsx (ooxml, embedded labels, table is COY_$(i));

NEXT i;

paulyeo11 — Sat, 16 May 2020 09:50:23 GMT

Hi Sir

Below script work fine , now i like to know how to how to change the SOURCE field , value A to A_COY

For Each i in 'A','B'

LOAD COY,

'$(i)' as SOURCE,

SALES

FROM

C:\TEMP\COY_$(i).xlsx (ooxml, embedded labels, table is COY_$(i));

NEXT i;

I am sure i can achieve above by Partial reload ? Any way to load it at the above load script ?

Paul

paulyeo11 — Sun, 17 May 2020 06:37:55 GMT

Hi Sir

I try to use your script for 2 different raw data , i need to combine them into 1 table. i get error.

can you advise me on below link :-

Paul

paulyeo11 — Fri, 29 May 2020 08:41:55 GMT

Hi Sir

Can you advise me on below :-

Paul