Where Exists in Another Table

[cbaqir]

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

[crystles · Accepted solution]

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

[#3]

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]

Maybe with something like this:

     Where Exists (TASK_ID)

[cbaqir]

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

[crystles]

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