Qlik Sense how to filter keys in load editor from the keys of another table

[electra]

Hi there,

I would like to filter the rows of table F_SPRINT in order to include only the rows where the 'issue key' is in the AUGUST table:

I am trying to do something like this in SQL:

select *

from F_SPRINT

where issue_key in (select issue_key from August_table)

In QS this is what I wrote but it doesnt work, I am not sure what is the right code:

F_SPRINT:
LOAD
*
FROM F_SPRINT
WHERE [Issue Key] in (
LOAD [Issue Key]
FROM ISSUE_KEYS_AUGUST_2022
)

Could you please help me?

Thanks so much,

Electra

[Mark_Winter]

You can use exists for this