topic Re: Trouble with Applay Map by reference key in App Development

Trouble with Applay Map by reference key

abedalraheem — Sat, 16 Nov 2024 04:13:23 GMT

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 .

Re: Trouble with Applay Map by reference key

sunny_talwar — Wed, 30 Oct 2019 12:24:15 GMT

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);

Re: Trouble with Applay Map by reference key

abedalraheem — Wed, 30 Oct 2019 12:27:12 GMT

I found the issue

I have to put Mapping in the master table before load

Re: Trouble with Applay Map by reference key

abedalraheem — Wed, 30 Oct 2019 12:28:20 GMT

yes you are right dear .

thank you .

🙂