Trouble with Applay Map by reference key

[abedalraheem]

Hi 

I'm using the below code to load two tables and generate third one ( DateBridge ) using a apply map

and the final object is generate master calendar for conical Date.

and the error given is map_id not found !!

Order:  table 1 
LOAD
OrderId,
OrderDate,
RequeriedDate
FROM [lib://Share folder (acig_appadmin)/conicalDate.xlsx]
(ooxml, embedded labels, table is Order);

OrderLine:  table 2
LOAD
OrderLineId,
ShippingDate,
OrderId,
amount
FROM [lib://Share folder (acig_appadmin)/conicalDate.xlsx]
(ooxml, embedded labels, table is OrderLine);

DateBridge: table 3
Load
OrderLineId,
Applymap('Order',OrderId,Null()) as CanonicalDate,
'Order' as DateType
Resident OrderLine;

Load
OrderLineId,
Applymap('Order',OrderId,Null()) as CanonicalDate,
'Required' as DateType
Resident OrderLine;

Load
OrderLineId,
ShippingDate as CanonicalDate,
'Shipped' as DateType
Resident OrderLine;

I'm tried to apply the below article here   about the canonical date , can anyone help me . 

thank you  .

[sunny_talwar · Accepted solution]

Did you forgot to add the keyword mapping or is that a typo?

Order:
Mapping 
LOAD OrderId,
            OrderDate,
            RequeriedDate
FROM [lib://Share folder (acig_appadmin)/conicalDate.xlsx]
(ooxml, embedded labels, table is Order);

[abedalraheem]

I found the issue 

I have to put Mapping in the master table before load

[abedalraheem]

yes you are right dear .

thank you .

🙂