Canonical Calendar not giving correct values

[AishwaryaVyas]

Hi, 

I created a bridge table to connect two calendars. 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.

@hic