Hi,
I created a bridge table to connect two calendars( please refer attached data model viewer). I wrote below script to create date bridge:
clnum2Invoice_Date:
MAPPING LOAD
clnum,
Invoice_Date
RESIDENT [qtable__Core_Headers];
auper2auDate:
MAPPING Load
auper,
auDate
Resident MasterCalendar;
DateBridge:
Load
clnum,
Applymap('clnum2Invoice_Date',clnum,Null()) as CanonicalDate,
'Shipping' as DateType
Resident client;
Load
clnum,
Applymap('auper2auDate',clnum,Null()) as CanonicalDate,
'Office_Supply' as DateType
Resident audit;
auper is in the format -"200907" and auDate is Calendar date. When I created a canonical calendar from this "Canonical Date '', I am not getting dates from "auper2auDate '' mapping .
Am I missing anything over here?
MasterCalendar has dates from 2009 to 2022 and MasterCalendar-5 has dates from 2020 to 2021. From this script I am getting only 2020 and 2021 dates. What should I do to get dates from 2009 to 2022(Master Calendar) for the Canonical Year? Please advise.
Qlik Sense Business
@Henric_Cronström
