I create the following table in the script:
Load ID AS APP_ID
In the expression I want to add a condition (in red below) that the expression will calculated only the id's that exists
in table Hired_Application..
IF(UPPER(STATUS)='HIRED' and ID EXISTS IN APP_ID from table Hired_Application ,DAYS)
Could you please advise?