Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 :
Thank you! I will try it!
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;