Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
abedalraheem
Contributor
Contributor

Trouble with Applay Map by reference key

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  .

 

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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
Contributor
Contributor
Author

I found the issue 

I have to put Mapping in the master table before load

 

abedalraheem
Contributor
Contributor
Author

yes you are right dear .

thank you .

🙂