topic Re: Join in QlikView

Join

rolandg1881 — Fri, 15 Nov 2024 23:38:19 GMT

Hi everybody!

One question please!

I have to tables

Table1

PRODUCT

LOAD

productname

productId

productgroupId

Table2

PRODUCTGROUP

LOAD:

productgroupId

productgroupname

----------------------------------------------------

In this case i see all productgroupnames in a selectionfield but i only want to see the productgroups witch included in the Product table

Can you help me please?

Greetings

Roland

Re: Join

QFabian — Thu, 12 Nov 2020 21:19:10 GMT

Hi!, you can add the EXISTS function to your second table load, check the code in red :

Table1

PRODUCT

LOAD

productname

productId

productgroupId

Table2

PRODUCTGROUP

LOAD:

productgroupId

productgroupname

From your source

WHERE EXISTS (productgroupId, productgroupId);

Here the link to qlik help about it :

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

Re: Join

rolandg1881 — Thu, 12 Nov 2020 21:27:17 GMT

Thank you! I will try it!

Re: Join

MayilVahanan — Fri, 13 Nov 2020 06:12:08 GMT

Hi @rolandg1881
You can try with left keep /left join also.

Product:

Load productname,productId,productgroupId from ursource;

PRODUCTGROUP:

Left keep (Product)

LOAD productgroupId,productgroupname from ursource;