topic Re: Error in apply map - Qlikview in QlikView

Error in apply map - Qlikview

andrea0901 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Below is my code i have written,

Binary [abcd\12345.qvw];

Tmp1:
Load
(REPLACE(LTRIM(REPLACE(BUKRS, '0', ' ')), ' ', '0')&BELNR&GJAHR) as Key_RBKP
Resident 12345;
Drop Table 12345;

Tmp2:
Mapping
LOAD
RB_BUKRS&RB_BELNR&RB_GJAHR as Key_RBKP,
UDATE
FROM
[xxxx\4567.qvd]
(qvd);

Now i need UDATE information from the above mapping table. From Tmp1 and Tmp2 Key_RBKP is my common key.

Final:

Load
ApplyMap('Tmp2',Key_RBKP) as Final_UDATE
Resident Tmp1;
Drop Table Tmp1;

But i am getting Final_UDate column is getting the values as same as Key_RBKP.

Please let me know where i have gone wrong.

Thanks in advance

Re: Error in apply map - Qlikview

anushree1 — Tue, 26 Feb 2019 09:35:56 GMT

Could you share the sample data

Re: Error in apply map - Qlikview

sunny_talwar — Wed, 27 Feb 2019 02:14:47 GMT

Do values from 12345 for (REPLACE(LTRIM(REPLACE(BUKRS, '0', ' ')), ' ', '0')&BELNR&GJAHR) match with value from 4567.qvd for RB_BUKRS&RB_BELNR&RB_GJAHR. Unless it is an exact match, the ApplyMap will give out the Key_RBKP as output... to check this, you can try this

Final:
Load ApplyMap('Tmp2',Key_RBKP, 'No Match') as Final_UDATE
Resident Tmp1;
Drop Table Tmp1;

Re: Error in apply map - Qlikview

andrea0901 — Wed, 27 Feb 2019 05:15:41 GMT

Hi Sunny,

Yes it is correct, it doesnt have exact match. It worked when i kept NA. Thanks a lot.