Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))
@TomBond77 maye be
Load * from
file.qvd
where( match(trim([Vendo]),'Not assigned')=0 or match(trim([Vendo]),'ES')=0 )
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],
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