Where clause with NOT

[TomBond77]

Hi experts

The following where clause doesn't work. Vendor is a text field.

Thanks for any help.

Tom

Load * from

file.qvd

where (Not([Vendor] = 'Not assigned')) Or (Not([Vendor] = 'ES'))

[Taoufiq_Zarra]

@TomBond77  maye be 

Load * from

file.qvd

where( match(trim([Vendo]),'Not assigned')=0 or  match(trim([Vendo]),'ES')=0 )

[TomBond77]

Thanks,  but it didn' work. Meanwhile I have solved it in the loading script:

If(Not([Vendor] = 'Not assigned'), IF(Not([Vendor] = 'ES'), [Vendor])) as [Vendor],

[PrashantSangle]

you can both condition in one if statement also

if(not match(Vendor,'No assigned','ES'),Vendor) as Vendor.

in where clause

Load * from tableName

where not match(Vendor,'Not assigned','ES');

Regards,

Prashant Sangle