Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if I understood well, without common field, it is a Cartesian product, i.e. all possible rows combinations
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://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
if I understood well, without common field, it is a Cartesian product, i.e. all possible rows combinations
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
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://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