Skip to main content
Announcements
Qlik Insider: Product Roadmap Edition on March 3, 1 PM ET: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
umashankarus
Contributor III

Applymap table not found error

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

13 Replies
umashankarus
Contributor III
Author

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
Contributor III
Author

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/