topic Re: Select * from table1 where table1.column in (select distinct values from table 2) How to do in Q in QlikView

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

Sakura — Sat, 16 Nov 2024 20:30:00 GMT

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?

Re: Select * from table1 where table1.column in (select distinct values from table 2) How to do in Q

Nicole-Smith — Mon, 08 Jul 2019 20:29:49 GMT

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/Exists.htm

Re: Select * from table1 where table1.column in (select distinct values from table 2) How to do in Q

Vegar — Tue, 09 Jul 2019 04:12:07 GMT

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 );

Re: Select * from table1 where table1.column in (select distinct values from table 2) How to do in Q

Brett_Bleess — Wed, 31 Jul 2019 17:37:25 GMT

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