topic table exception in QlikView

table exception

Wed, 06 Nov 2013 12:58:36 GMT

Hi,

I'm struggling to bring everything they have in a FACT table except his match in a table SUPPLEMENTARY_terminations.

I did but did not work as below:

Left Join (Apparel)

LOAD IDFuncResComp,

IDFuncResCompCont

Resident Rescisoes_comp Where not Exists (IDFuncResComp, IDFuncResComp);

Re: table exception

tresB — Wed, 06 Nov 2013 13:11:13 GMT

Try mentioning the table name like:

Resident Rescisoes_comp Where not Exists (EarlierTable.IDFuncResComp, IDFuncResComp);

Re: table exception

Wed, 06 Nov 2013 14:08:44 GMT

I did it, but still did not work.

Re: table exception

Wed, 06 Nov 2013 14:32:09 GMT

Hi,

Hope this helps.

Regards,

Anju

Re: table exception

marcus_malinow — Wed, 06 Nov 2013 14:34:54 GMT

Hi Hugo,

am I right in understanding that you only wish to retain those records in Apparel where you do not have a matching IDFuncResComp in Rescisoes_comp?

If so, you may have a couple of issues.

The not exists clause you have won't work as all the IDFuncResComp values have already been loaded into your resident table, so no records would match the NOT EXISTS clause.

Also, you may want to change this JOIN to a KEEP. See this link for some useful information on this - http://community.qlik.com/groups/qvscriptor-from-schema-to-script/blog/2011/11/11/understanding-join-keep-and-concatenate

Marcus