Join

[rolandg1881]

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

[QFabian]

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

[rolandg1881]

Thank you! I will try it!

[MayilVahanan]

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;