Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Louveduval
Creator
Creator

Canonical calendar

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 ? 

map.jpg

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 

Labels (1)
4 Replies
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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Louveduval
Creator
Creator
Author

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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Louveduval
Creator
Creator
Author

Louveduval_0-1672301791748.png

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