topic Re: How to write a code for subquery in Qliksense in Connectivity & Data Prep

How to write a code for subquery in Qliksense

aatish12345 — Thu, 30 Sep 2021 08:30:22 GMT

Hi Everyone,

I have a SQL code, for example:

Select Column 1 from Table1 where

Column2 IN (select column3 from table 2)

I want to achieve this through qlik code.

Can someone help here plz...

Aatish

abhijitnalekar — Thu, 30 Sep 2021 09:58:23 GMT

Hi Atish,

You can achieve the same by using the where Exist script function.

Please go through with the below link for example.

jyothish8807 — Thu, 30 Sep 2021 10:12:51 GMT

May be like this:

Table1:

Load

column3

from table 2;

Table2:

Load

Column 1 from Table1 where exists (column3 ,Column2);

Drop table Table1;