Multiple mapping records

[#1]

Hi everyone,

I have basically 2 tables :

• A FACT table containing ID_PROJECT and EUROS
• A PRECISION table containing ID_PROJECT and RESPONSABILITY_CENTER

The point is getting EUROS by RESPONSABILITY CENTER.
I've tried lookup, but i have several RC for the same PROJECT.
Ive tried ApplyMap, but still the same issue.

MAP_PRJ_CA:
MAPPING LOAD
[Project ID] as ID_PRJ_TIME_MAP,
CA as CA_MAP
FROM
referentials\clients\PROJETS_PORTICO.csv
(txt, codepage is 1252, embedded labels, delimiter is ';', msq)
WHERE Période = 'MARCH';

FACT:
LOAD
ResourceDriverSplit as EUROS
ApplyMap('MAP_PRJ_CA', [Project ID], NULL()) as CA,

I need your help !

Many thanks in advance for ur replies.

[tresesco]

Probably you have to use your fact table as mapping table as:

FACT:
MAPPING LOAD
 [Project ID],
 ResourceDriverSplit // Euros
FROM ... ;

MAPPED:
LOAD
 CA,
 ApplyMap('FACT', [Project ID], NULL()) as MAPPED_EUROS
FROM ....;