topic Re: Case 309 How to create one expression to replace multiple expression ? in QlikView

Case 309 How to create one expression to replace multiple expression ?

paulyeo11 — Mon, 18 May 2020 04:06:02 GMT

Hi All

I have below script work fine , except for the red color expression not working :-

MAP_NAME_A:
mapping LOAD RAW,
NAME
FROM
[MAP_A.xlsx]
(ooxml, embedded labels, table is MAP_A);

MAP_NAME_B:
mapping LOAD RAW,
NAME
FROM
[MAP_B.xlsx]
(ooxml, embedded labels, table is MAP_B);

For Each i in 'A','B'

LOAD
COY,
SALESMAN,
'$(i)' as SOURCE,

ApplyMap('MAP_NAME_A',[SALESMAN],'OTHERS') as [SALESMANE_A],
ApplyMap('MAP_NAME_B',[SALESMAN],'OTHERS') as [SALESMANE_B],

ApplyMap('MAP_NAME_'$(i)'',[SALESMAN],'OTHERS') as [SALESMANE],

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

Hope some one can advise me how to do it ?

I get below error msg :-

Error in expression:
')' expected
LOAD

The final result :-

Re: Case 309 How to create one expression to replace multiple expression ?

Saravanan_Desingh — Mon, 18 May 2020 22:44:09 GMT

ApplyMap('MAP_NAME_$(i)',[SALESMAN],'OTHERS') as [SALESMANE],

Remove single quote around $(i). Within a String, if you use $, the variable will be automatically replaced with the value.

Re: Case 309 How to create one expression to replace multiple expression ?

paulyeo11 — Mon, 18 May 2020 23:00:30 GMT

Hi Sir

Many thank it work fine now .

Paul