topic Why my Applymap return key value ? in App Development

Why my Applymap return key value ?

Metalix64 — Sat, 16 Nov 2024 06:50:48 GMT

Hi there,

I have a problem with my function ApplyMap();

My mapping loads well but when I want to use the function ApplyMap, it returns me the value of the key and not its corresponding value. See the example below :

My Mapping table :

My other table from QVD file:

My code :

Mapping:
MAPPING LOAD Distinct
    code,
    family
FROM [lib://PATH\Mapping.xlsx]
(ooxml, embedded labels, table is FPY);

FPY2:
LOAD
    *
FROM [lib://PATH/PROD0145.QVD]
(qvd);

FPY_MAP :
LOAD *,
ApplyMap('Mapping',code) as Mapping
Resident FPY2;

STORE FPY_MAP INTO [lib://PATH/MAPPING_TEST.csv] (txt);

Re: Why my Applymap return key value ?

Somasundaram — Wed, 16 Jan 2019 08:58:03 GMT

Hi,

It seems your mapping table 'code' format is different from fact table.

Please check and change the correct format.

Re: Why my Applymap return key value ?

Metalix64 — Wed, 16 Jan 2019 09:07:24 GMT

Hi,

Thank you for your answer, indeed I force the type of my field with the function text () and it works now.

My new code :

Mapping:
MAPPING LOAD Distinct
text(code) as newcode,
family
FROM [lib://PATH\Mapping.xlsx]
(ooxml, embedded labels, table is FPY);

FPY2:
LOAD

text(AGENT) as newcode,
*
FROM [lib://PATH/PROD0145.QVD]
(qvd);

FPY_MAP :
LOAD *,
ApplyMap('Mapping',text(newcode)) as Mapping
Resident FPY2;

Thx.