topic Re: Apply Map error:map_id not found in QlikView

Apply Map error:map_id not found

Fri, 03 Mar 2017 17:16:22 GMT

I get "Apply Map error:map_id not found" when I run the below script. What am I doing wrong? I want to replace the longer name (PRACTICE) with the shorter name (ShortPractice) but otherwise use the current name.

Practices:

Mapping LOAD * INLINE [

PRACTICE, ShortPRACTICE

Basic Materials, Materials

Corporate Professional Services, CPS

'Equipment, Engineering and Construction', EEC

Human Resources, HR

Industrial and MRO, I&MRO

IT/Telecom, IT/T

UNCATEGORIZED, Uncat

];

Contracts:

LOAD

ApplyMap('Practices',PRACTICE,PRACTICE) as PRACTICE

FROM

[QVD-Generators\CSW\CSW.qvd]

(qvd);

Re: Apply Map error:map_id not found

vishsaggi — Fri, 03 Mar 2017 17:25:27 GMT

Does your QVD has the field name PRACTICE?

Re: Apply Map error:map_id not found

Fri, 03 Mar 2017 18:26:42 GMT

Hi Ed,

I tried to recreate ApplyMap error: map_id not found this is coming for me only when I give wrong mapping table.
Could you please cross check in your script once whether mapping table name is exactly the same as the Applymap() mentioned

Re: Apply Map error:map_id not found

nikhil_deokar — Mon, 06 Mar 2017 05:51:40 GMT

Hey Ed,

First you check whether the PRACTICE field exists in qvd or not

if exists then write the following syntax:-

ApplyMap('Practices',PRACTICE,Null()) as ShortPRACTICE

Regards

Nikhil Deokar

Re: Apply Map error:map_id not found

Tue, 07 Mar 2017 14:34:53 GMT

Vishwarath - Yes, the QVD does have PRACTICE as a field

Ravindra - I don't understand your question, you can see above that I named the inline table Practices

Nikhil - Replacing non-matching fields with a null does not make a difference, besides that's not what I want to do.

Re: Apply Map error:map_id not found

Peter_Cammaert — Tue, 07 Mar 2017 14:53:38 GMT

QlikView 12.xx ?

QlikView 11.xx doesn't bother about non-existent mapping tables. ApplyMap just returns Null.

Re: Apply Map error:map_id not found

Peter_Cammaert — Tue, 07 Mar 2017 15:07:50 GMT

Just answering my own question. This error message has been introduced in QV12.10IR (What a pity!!!)

If the Mapping table does exist at the time of the ApplyMap call, you've probably hit a bug of some sorts. If nothing helps, better contact Qlik Support.

Re: Apply Map error:map_id not found

amanjain57 — Tue, 07 Mar 2017 17:48:31 GMT

I am facing the same error.

Any update on this guys?

Re: Apply Map error:map_id not found

avinashelite — Wed, 08 Mar 2017 06:10:04 GMT

Strange !! could you share the sample QVD so that we could try ?

Re: Apply Map error:map_id not found

NareshGuntur — Wed, 08 Mar 2017 15:11:58 GMT

One possible reason I could think of is

The name "Practices"(Mapping table name)... can you cross check whether you are using the same name in the apply map as well(case sensitive)

Naresh

Re: Apply Map error:map_id not found

ruben_antelo — Tue, 14 Mar 2017 16:44:32 GMT

It worked for me. Thank you, Peter.

Re: Apply Map error:map_id not found

rwunderlich — Wed, 15 Mar 2017 03:33:03 GMT

As a debugging exercise:

1. Remove the "Mapping" prefix from the script.

2. Place an "Exit Script;" statement after the load of the "Practices" load and then reload.

Does the "Practices" table appear in the table viewer?

-Rob

Re: Apply Map error:map_id not found

amanjain57 — Wed, 15 Mar 2017 13:29:17 GMT

I got the same error, but i was doing it wrong. I did not mention Apply Map in my script.

It works now.

Thanks

Re: Apply Map error:map_id not found

Tue, 21 Mar 2017 19:58:17 GMT

Thank you! I tried that and realized a table was not being created. Then I went back and found a previous inline table I had loaded did not include a "]" at the end! But this never showed up as an error until I tried to apply the map.

Re: Apply Map error:map_id not found

s_fontenot — Fri, 15 Dec 2017 17:26:46 GMT

Hello,

I had the same Issue please recheck the order of mapping Script.

Place the mapping script first,

Step-1:

Mapping LOAD ShipperID,

CompanyName AS ShipperName;

and follow up with

Step-2:

Orders:

LOAD CustomerID,

EmployeeID,

FreightWeight,

OrderDate,

OrderID,

ApplyMap('Shippers_map',ShipperID,'Unknown Shipper') as ShipperName,

ShipperID;

SQL SELECT CustomerID,

EmployeeID,

FreightWeight,

OrderDate,

OrderID,

ShipperID

FROM orders;

Cheers!!

Re: Apply Map error:map_id not found

Anil_Babu_Samineni — Sat, 16 Dec 2017 04:13:52 GMT

You should open new thread, Anyway Where is table Shippers_map placed?

Re: Apply Map error:map_id not found

s_fontenot — Fri, 22 Dec 2017 15:26:18 GMT

Hello Anil,

Please find the full script.

Step-1:

LIB CONNECT TO 'DBconnection(Name) '

Shippers_map:

Mapping LOAD ShipperID,

CompanyName AS ShipperName;

and follow up with

Step-2:

Orders:

LOAD CustomerID,

EmployeeID,

FreightWeight,

OrderDate,

OrderID,

ApplyMap('Shippers_map',ShipperID,'Unknown Shipper') as ShipperName,

ShipperID;

SQL SELECT CustomerID,

EmployeeID,

FreightWeight,

OrderDate,

OrderID,

ShipperID

FROM orders;

Thanks,

Re: Apply Map error:map_id not found

Anil_Babu_Samineni — Fri, 22 Dec 2017 15:34:16 GMT

script seems okay, What is the issue?

Re: Apply Map error:map_id not found

Anonymous — Sat, 14 Apr 2018 00:13:35 GMT

It worked for me too. TY Peter 😃

Re: Apply Map error:map_id not found

Frank_Huning — Wed, 30 Aug 2023 18:58:56 GMT

I had the same issue. My solution was to add a semi-colon to end a variable setting in the previous tab (which I forgot) 😉