MAPPING LOAD & APPLYMAP

[David_K]

Hello Fellow Qlik Sense Users,

I am trying utilize the Mapping function in Qlik Sense, however I cannot seem to get he response I am aiming to see.

My script is as below:

CHILD_PARENT_CONVERSION:
Mapping Load
CHILD,
PARENT
FROM [lib://Customer_Support/CODES.xls]
(ooxml, embedded labels, table is AG_2_UK);

ORDERS:

LOAD
ORDER_NUMBER,
MODEL_NUMBER,
ApplyMap('CHILD_PARENT_CONVERSION', 'PARENT','UNKNOWN') AS PRINCIPAL,
....

The Output I receive details the PRINCIPAL as "UNKNOWN" 

I have looked at various comments in the forum, and cannot see where I have gone wrong, can I please ask for some further guidance.

Many thanks,

David

[Kushal_Chawda]

@David_K  remove single quotes around field name  PARENT

ApplyMap('CHILD_PARENT_CONVERSION', PARENT,'UNKNOWN') AS PRINCIPAL,

[David_K]

Hi Kushal,

Thanks for the quick reply.

I have tried you suggestion, and the load script comes back with:

The following error occurred:

Field PARENT not found

The error occurred here:

ORDERS:

LOAD
ORDER_NUMBER,
MODEL_NUMBER,
ApplyMap('CHILD_PARENT_CONVERSION', PARENT ,'UNKNOWN') AS PRINCIPAL,

Any further suggestions?

Thnaks,

David

[vuan]

@David_K  It is important for mapping load that the key is loaded first that the value

CHILD_PARENT_CONVERSION:
Mapping Load
PARENT,
CHILD
FROM [lib://Customer_Support/CODES.xls]
(ooxml, embedded labels, table is AG_2_UK);

ORDERS:

LOAD
ORDER_NUMBER,
MODEL_NUMBER,
ApplyMap('CHILD_PARENT_CONVERSION', PARENT, 'UNKNOWN') AS PRINCIPAL,
....

Kind regards Anh Toan

[Kushal_Chawda · Accepted solution]

@David_K  It seems PARENT field is not available in the ORDER able where you have applymap statement. You need to provide field name from ORDER Table matching to field in mapping table