
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you do a binary load by any chance?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this thread which talks about binary load:
https://www.analyticsvidhya.com/blog/2015/03/qlikview-binary-load/

- « Previous Replies
-
- 1
- 2
- Next Replies »