topic Re: Applymap table not found error in QlikView

Applymap table not found error

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

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

Re: Applymap table not found error

sunny_talwar — Wed, 25 Jan 2017 03:31:31 GMT

Is this the complete script? or do you have something before this part of the script? May be try giving the name explicitly for the tables:

HZ_PARTIES:

NoConcatenate

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;

PER_ALL_PEOPLE_F:

NoConcatenate

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;

Re: Applymap table not found error

vardhancse — Wed, 25 Jan 2017 04:30:32 GMT

Hi,

Mapping table should be loaded before the table.

Mapping table should have 2 fields:

1. ID

2. data field

Re: Applymap table not found error

ramasaisaksoft — Wed, 25 Jan 2017 06:39:17 GMT

Hi Shankar,

1)I hope some code is there either it may be before of this code else after this code.

why because i didn't see apply map() then what is the use of Mapping Load.

2)You already know Mapping table will need to have mandatory 2 fields (1st ID field which will help to you to search the Primary Key ID,2nd Field is data field which will hive depends on the the ID field it will lookup the Names/Data and if that is empty data we will replace with our own data.)

So may be you confused ,if possible please share your qvw file so that our folks will help to you else share your full script and expected output also.

Re: Applymap table not found error

rahulpawarb — Wed, 25 Jan 2017 06:51:13 GMT

Hello Umashankar,

Hope you are doing well!

Could you please share the complete script (you can morph the certain contents)? This will help us to dig down the issue.

However, MAPPING Statement is a specific type of table that has the following properties:

• It can only have two columns, the first being the lookup value and the second being the mapping value to return.

• It is a temporary table. At the end of the script, QlikView automatically removes the table from the data model.

Regards!

Rahul

Re: Applymap table not found error

kuczynska — Wed, 25 Jan 2017 10:14:26 GMT

Hi.

I would agree with Sunny, that if there is anything loaded before PER_ALL_PEOPLE_F and has the same columns this will trigger auto concatenate, making PER_ALL_PEOPLE_F a part of another table and it has a different name.

Using - like Sunny suggested - noConcatenate statements should help.

good luck!

Re: Applymap table not found error

umashankarus — Wed, 25 Jan 2017 14:41:43 GMT

Hi,

Thanks for the reply

Yes, there are codes subsequent to the above, where in 'Applymap' is applied

I followed the suggestions and added 'NoConcatenate'

It worked charm

Still I have a question

In this context, both the tables do not have any columns in common

So how does 'NoConcatenate' helps here ?

Re: Applymap table not found error

umashankarus — Wed, 25 Jan 2017 14:43:49 GMT

Hi,

Thanks for taking time to respond

Yes, there are codes after the above where in Applymap is applied

Re: Applymap table not found error

sunny_talwar — Wed, 25 Jan 2017 14:44:23 GMT

I asked if there was script before this (not after). The reason I asked that was because you may have another table where you have same field names as PER_ALL_PEOPLE_F. Since you mentioned that NoConcatenate helped, I am guessing that you did have them and that is why NoConcatenate helped in creating the table with this name whereas it might have been getting auto-concatenated to the other table with same field names

Re: Applymap table not found error

umashankarus — Wed, 25 Jan 2017 14:44:42 GMT

Hi,

Thanks for the response

The above suggestion seems to work but waiting for some more clarification

Re: Applymap table not found error

umashankarus — Wed, 25 Jan 2017 14:46:41 GMT

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

Re: Applymap table not found error

sunny_talwar — Wed, 25 Jan 2017 14:49:19 GMT

Do you do a binary load by any chance?

Re: Applymap table not found error

umashankarus — Wed, 25 Jan 2017 15:05:24 GMT

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 ?

Re: Applymap table not found error

sunny_talwar — Wed, 25 Jan 2017 15:08:59 GMT

Check this thread which talks about binary load:

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