table exception

[#1]

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

[tresesco]

Try mentioning the table name like:

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

[#3]

I did it, but still did not work.

[#4]

Hi,

Hope this helps.

Regards,

Anju

[marcus_malinow]

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...

Marcus