Error in apply map - Qlikview

[andrea0901]

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

[anushree1]

Could you share the sample data

[sunny_talwar · Accepted solution]

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;

[andrea0901]

Hi Sunny,

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