Join dates between 3 tables

[sifatnabil]

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.

[tresesco]

Can't you create a Key field in the new table as well?

[Anonymous]

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

[sifatnabil]

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".

[#5]

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

[sifatnabil]

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!