Applymap table not found error

[umashankarus]

Hi Experts,

Can you pl let me know the mistake in this script. On Reload, table not found error is thrown

SCRIPT:

select
PARTY_ID as HZP_PARTY_ID,
PARTY_NAME as HZP_PARTY_NAME,
PARTY_NUMBER as HZP_PARTY_NUMBER
from apps.HZ_PARTIES ;


MAP_PARTYID_TO_CUSTOMERNAME:
Mapping LOAD HZP_PARTY_ID, HZP_PARTY_NAME RESIDENT HZ_PARTIES;


select
PERSON_ID,
EMPLOYEE_NUMBER,
FULL_NAME
from
apps.PER_ALL_PEOPLE_F;


MAP_EMPID_TO_NAME:
Mapping LOAD PERSON_ID, FULL_NAME RESIDENT PER_ALL_PEOPLE_F;

Error:

Table not found

MAP_EMPID_TO_NAME:

Mapping LOADD PERSON_ID, FULL_NAME RESIDENT PER_ALL_PEOPLE_F;

Subsequent Result:

Did not load this mapping - MAP_EMPID_TO_NAME:

Connected

HZ_PARTIES 2,080 Lines fetched

MAP_PARTYID_TO_CUSTOMERNAME << HZ_PARTIES 2,080 Lines fetched

MAP_PARTYID_TO_CUSTOMERNAME << PER_ALL_PEOPLE_F 620 Lines fetched

Thanks,

Umashankar

[umashankarus]

Hi,

This particular .qvw file contains just this set of codes only

But in real use case, there are codes after this set and not before this code

[sunny_talwar]

Do you do a binary load by any chance?

[umashankarus]

I am new to Qlikview

I am not sure about your question and let you know if that is the case

How to check and confirm on this ?

[sunny_talwar]

Check this thread which talks about binary load:

https://www.analyticsvidhya.com/blog/2015/03/qlikview-binary-load/