Select * from table1 where table1.column in (select distinct values from table 2) How to do in Qlik?

[Sakura]

Select * from table1 where table1.column in (select distinct values from table 2) How to do in Qlik?

Load * from table where table.col in (load distict column from table2)

How to perform the above operation?

[Nicole-Smith]

You'll want to use the exists() script function.

You can read more about it and find some examples here: https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/InterRecordFunctions/E...

[Vegar · Accepted solution]

Just like @Nicole-Smith mentions EXISTS is the keyword for solving this issue. Try something like this.

Table2:

Load  Column, Column 1, Column 2

From Table2.qvd (qvd); 

Table:

Load Col, Col1, Col2, Col3

FROM table.qvd (qvd) 

where exists(Column, Col );

[Brett_Bleess]

Sakura, did the above posts solve your issue?  If so, be sure to give them credit by clicking the Accespt as Solution button, you can check multiple replies if they helped as well.  If not, please provide further information, and if you cannot click the button, just leave a new reply confirming they did help, and we can mark things for you.

Regards,
Brett