Join

[parvez933]

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

[Taoufiq_Zarra · Accepted solution]

@parvez933 

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

[parvez933]

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

[Brett_Bleess · Accepted solution]

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/Scrip...

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

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