topic Re: Join dates between 3 tables in QlikView

Join dates between 3 tables

sifatnabil — Tue, 11 Mar 2014 06:03:28 GMT

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.

Re: Join dates between 3 tables

tresB — Tue, 11 Mar 2014 06:09:39 GMT

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

Re: Join dates between 3 tables

Anonymous — Tue, 11 Mar 2014 06:12:33 GMT

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

Re: Join dates between 3 tables

sifatnabil — Tue, 11 Mar 2014 06:13:11 GMT

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

Re: Join dates between 3 tables

Tue, 11 Mar 2014 06:37:32 GMT

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

Re: Join dates between 3 tables

sifatnabil — Wed, 12 Mar 2014 06:11:57 GMT

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!