Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Syntax error.
Use this
where not Exists (DelUnit,Units)
Cheers,
Naresh
What is your error?
Remove Units:
where Units not Exists (DelUnit,Units) ;
Hi Robert,
It is Garbage error after statement.