topic Re: Join in QlikView

Join

parvez933 — Wed, 25 Nov 2020 16:16:04 GMT

Good Day Everyone!

I am new to Qlikview. Please help in understanding the below scenario

In Qlik can we join 2 tables without any common field / key, without any alias and that to when the dimension table have 2 ID fields?!

Example:

Fact_Table:

Load ID, Name from xxxxxxxxxxxxx;

Dimension_Table:

Load ID1, ID2, Date from xxxxxxxxxxx;

If I use a join (left/right/outer), how the thinks gone a work!!!

Please help!

Regards,

Parvez

Re: Join

Taoufiq_Zarra — Wed, 23 Sep 2020 10:49:24 GMT

@parvez933

if I understood well, without common field, it is a Cartesian product, i.e. all possible rows combinations

Re: Join

parvez933 — Wed, 23 Sep 2020 10:59:31 GMT

Hi Taoufiq,

The ID1, and ID2 from the 2nd table have some matching records with ID in first table!

Example:

Table1:

ID, Name

10, ASD

11, SDD

12, DDD

Table2:

ID1, ID2, Date

10, 23, xxxxx

23, 10, xxxxxx

11, 44, xxxxx

44, 11, xxxx

is this case can be handled!!

Both ID1, and ID2 are not matching with ID but some of the ID1, and ID2 will match with the ID.

Regards,

Parvez

Re: Join

Brett_Bleess — Tue, 20 Oct 2020 13:38:24 GMT

Going to drop in a couple of Help Doc links, this is the official doc on things, so should clear things up, and the other thing is some Design Blog link(s) depending upon what I can find related to Join that may potentially help.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Join.htm

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Keep.htm

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Hopefully these will clarify things a bit better for you.

Regards,
Brett