topic Where Exists in Another Table in QlikView

Where Exists in Another Table

cbaqir — Thu, 15 Oct 2015 19:45:48 GMT

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

Re: Where Exists in Another Table

crystles — Thu, 15 Oct 2015 19:48:36 GMT

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

Re: Where Exists in Another Table

Thu, 15 Oct 2015 19:49:04 GMT

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);

Re: Where Exists in Another Table

Anonymous — Thu, 15 Oct 2015 19:50:00 GMT

Maybe with something like this:

Where Exists (TASK_ID)

Re: Where Exists in Another Table

cbaqir — Thu, 15 Oct 2015 19:52:49 GMT

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

Re: Where Exists in Another Table

crystles — Thu, 15 Oct 2015 19:56:35 GMT

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