IN Logic in qliksense

[Mahamed_Qlik]

Hi All,

How to write below query in script:

select ID from A
where A.ID IN ( select ID from B)

[MarcoWedel · Accepted solution]

table1:
LOAD ID from B;

table2:
LOAD ID from A
where Exists(ID);

Drop Table table1;

[Mahamed_Qlik]

Thanks Marco