Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Where Exists in Another Table

In my load, I am loading TASK_ID (among other things) from a source called APP_MS and another TASK_ID (among other things) from a source called DM_STAT_TASK. I want to write the equivalent of loading TASK_ID from DM_STAT_TASK where TASK_ID exists in APP_MS. What would the syntax be?

Thanks

1 Solution

Accepted Solutions
crystles
Partner - Creator III
Partner - Creator III

Just so I understand, if you want to load table APP_MS and DM_STAT_TASK but only keep the TaskID values where they occur in APP_MS, then you just do a Left Join.

Load

TaskID

APP_MS

Left Join(APP_MS)

Load

TaskID

DM_STAT_TASK

View solution in original post

5 Replies
crystles
Partner - Creator III
Partner - Creator III

Just so I understand, if you want to load table APP_MS and DM_STAT_TASK but only keep the TaskID values where they occur in APP_MS, then you just do a Left Join.

Load

TaskID

APP_MS

Left Join(APP_MS)

Load

TaskID

DM_STAT_TASK

Not applicable

You need load firt APPS_MS...after you need put where existes , for example:

DM_STAT_TASK

LOAD *

FROM

     DM_STAT_TASK

WHERE

     EXISTS(TASK_ID,TASK_ID);

Anonymous
Not applicable

Maybe with something like this:

     Where Exists (TASK_ID)

cbaqir
Specialist II
Specialist II
Author

That is correct. I was doing a left join but wasn't indicating the table name. I will try it now, thanks!

crystles
Partner - Creator III
Partner - Creator III

Glad I could help. I've done the same thing before. Thanks!