Filter data where in a table

[Rena]

Hi all, I would like to know how to load data when we want to filter like this

-------------------------

where A_column in (select * from table_01 )

-------------------------

by using Qlik script

Thanks!

[Filippo_Nicolussi_P]

Hello 

You could preload in a temp table the "Temp: select the_field_in_table_01_of _interest as A_column from datasource_table_01;  then use a where exists(A_column) ;  

Here a similar blog  regarding exists() usage https://community.qlik.com/t5/QlikView-App-Dev/Where-exists-function/td-p/27614  

and the official help https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/InterRe...