Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have linked the dates in 2 tables via a Link Table, but now I would like to link the date from another table to these 2 tables. How would I do it?
Should this be done as a join? Thanks.
Can't you create a Key field in the new table as well?
Hi Sifat,
Not sure if this is relevant to you but there was a recent blog post by Henric Cronstrom around the use of canonical dates:
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
Hi tresesco, thanks for your reply. I tried doing that, but it creates synthetic tables for some reason. I think it's because the table "TradeReport" is already linked to "GUIBOSReport" via the field "DerivedTrade_ID".
Try creating a key in the source (Pricing Table I presume)
Trade_Report:
Load DerivedTrade_ID,
Key as %%_Trade_Report_Key,
(other fields)
From (Source etc)
;
Pricing_Table:
Load Key as %%_Pricing_Table_Key,
(other fields inc Date)
From (source etc etc)
;
Then in the Link Table..
LinkTable:
Load %%_Pricing_Key as %%_Key
Resident Pricing_Table ;
Outer Join
Load %%_Trade_Report_Key as %%_Key
Resident Trade_Report;
Not sure - but HTH
Hi all,
Thanks for your replies. I've been able to resolve this issue; the DerivedTrade_ID key actually already joined the dates from all 3 of the above tables. Thanks!