Using Not Exist

[mhmmd_srf]

Hi All,

I want to delete from qvd for few Units. I have created Inline load and used that in Not Exists function. Below is my code:

UnitDelete:

Load * Inline

[DelUnit,

10,

100

];

Transaction:

LOAD

    CUSTOMER,

    "ABC #",

    "Invoice #",

    "Invoice Qty",

    "Invoice Type",

    "Total Extended Cost",

    Units,

   "Customer Group"

FROM [lib://QVDs/Transactions_01_09132016.qvd](qvd)

where Units not Exists (DelUnit,Units) ;

But I am getting error. Could you please help me on this.

Thanks in advance for your help.

Regards,

Sarif

[NareshGuntur]

Syntax error.

Use this

where not Exists (DelUnit,Units)

Cheers,

Naresh

[robert_mika]

What is your error?

[MindaugasBacius · Accepted solution]

Remove Units:

where Units not Exists (DelUnit,Units) ;

[mhmmd_srf]

Hi Robert,

It is Garbage error after statement.