Extract data from SAP- Where clause - Qlik Community

Anonymous · ‎2017-08-21

How do you write 'Not Equal To' when extracting data from SAP? <> or != doesn't work. Thanks!

devarasu07 · ‎2017-08-21

Hi,

Try like this,

load * from table

Where

VRGAR='F'

and PALEDGER='01'

and Not match (WAAG,'01','02')

and Len(WAAG)>0;

Hope this helps to you

Thanks, Deva

Anil_Babu_Samineni · ‎2017-08-21

you can write this in qlik <>. If you making in SQL then define !=

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful