topic Re: ApplyMap Fails with ApplyMap error:map_id not found in QlikView

ApplyMap Fails with ApplyMap error:map_id not found

Wed, 25 Nov 2020 16:16:04 GMT

Using the following 2 maps on 1 table that gets qualified as well.

SCRIPT:

/////////////////////////////////////////////////////////////////////////////////////////////////////////////

HelpdeskStatusMap:
MAPPING LOAD Helpdesk.Status AS Status, Description as ID
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

HelpdeskActivityStatusMap:
MAPPING LOAD Helpdesk.Activity.Status AS ActivityStatus, Description as ID
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

HelpDesk:
QUALIFY

Status,

ActivityStatus,;

LOAD

ApplyMap('HelpdeskStatusMap',Status,'Unknown') as Status,

ApplyMap(HelpdeskActivityStatusMap,ActivityStatus,'Unknown') as ActivityStatus,
SQL SELECT *
FROM ARSystem.dbo.HelpDeskJoinSolution;

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

And I get ApplyMap error:map_id not found.

Attached find the CSV's as well.

Must be a syntax thing someone HELP!

Re: ApplyMap Fails with ApplyMap error:map_id not found

adamdavi3s — Fri, 09 Dec 2016 13:31:41 GMT

Your second applymap needs the apostrophes around the table name

Re: ApplyMap Fails with ApplyMap error:map_id not found

Anonymous — Fri, 09 Dec 2016 13:32:11 GMT

Hi,

i think,in second apply map statement you forgoted the table name to put in Quotes.

this is what you posted:

ApplyMap(HelpdeskActivityStatusMap,ActivityStatus,'Unknown') as ActivityStatus,

i think this is correct statement:

ApplyMap('HelpdeskActivityStatusMap',ActivityStatus,'Unknown') as ActivityStatus

Thanq.

Re: ApplyMap Fails with ApplyMap error:map_id not found

sunny_talwar — Fri, 09 Dec 2016 13:32:48 GMT

Is this a typo? Missing single quotes around the table name in your second ApplyMap function?

ApplyMap('HelpdeskStatusMap',Status,'Unknown') as Status,

ApplyMap('HelpdeskActivityStatusMap',ActivityStatus,'Unknown') as ActivityStatus,

Re: ApplyMap Fails with ApplyMap error:map_id not found

Anil_Babu_Samineni — Fri, 09 Dec 2016 13:33:50 GMT

Might be here is the typo error, Check for me and then see

HelpdeskStatusMap:
MAPPING LOAD Helpdesk.Status AS Status, Description as ID
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

HelpdeskActivityStatusMap:
MAPPING LOAD Helpdesk.ActivityStatus AS ActivityStatus, Description as ID // I've removed one Dot here for Activity.Status
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

HelpDesk:
QUALIFY

Status,

ActivityStatus,; // I've removed Camma Here

LOAD

ApplyMap('HelpdeskStatusMap',Status,'Unknown') as Status,

ApplyMap('HelpdeskActivityStatusMap',ActivityStatus,'Unknown') as ActivityStatus, // I've added apostrophes / Single colon here
SQL SELECT *
FROM ARSystem.dbo.HelpDeskJoinSolution;