ApplyMap Fails with ApplyMap error:map_id not found

[#1]

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!

[adamdavi3s]

Your second applymap needs the apostrophes around the table name

[Anonymous]

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.

[sunny_talwar]

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,

[Anil_Babu_Samineni]

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;