Canonical calendar

[Louveduval]

Hello , 

I'm sorry, I know that we have already a lot of topics about that but I can't do it . 

I need to join the calendar ACHAT , the calendar VENTE and date stock to the Canonial calendar . Can you help me ? 

DateBridge:
Load
"CLE article depot",
"CLE DATE achat" as CanonicalDate
Resident  STOCK;

Load
"CLE article depot",
"CLE DATE  vente" as CanonicalDate
Resident STOCK;

Load
"CLE article depot",
"Date stock" as CanonicalDate
Resident STOCK;

Best regard 

[Taoufiq_Zarra]

@Louveduval the best is to use MasterCalendar

but if I understood correctly you can use

DateBridge:
Load
"CLE article depot",
'ACHAT' as var,
"CLE DATE achat" as CanonicalDate
Resident STOCK;

Load
"CLE article depot",
'VENTE' as var,
"CLE DATE vente" as CanonicalDate
Resident STOCK;

Load
"CLE article depot",
'STOCK' as var,
"Date stock" as CanonicalDate
Resident STOCK;

and use var to distinct each date

[Louveduval]

Sadly it doesn't work : Field "CLE DATE achat"  not found .

I don't understand why I can't made the bridge. 

[Taoufiq_Zarra]

@Louveduval  can you share a sample data and the outpout souhaité ? Merci

[Louveduval]

I want have the same [CLE_DATE_BL_FACTURE achat] and CanoniclDate for a CLE_article_depot