Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I want to where data

Header 1Header 2Header 3
PriceRef.1

Ref.2

500Oil-
900WAG2
700WAG-
800WAG3
799WAG-

where ref.1 not Oil and where ref.1 WAG not 2,3

EX.

Header 1Header 2Header 3
PriceRef.1Ref.2
700WAG-
900--
10 Replies
Anonymous
Not applicable
Author

I load data from SQL but I want to load some data  and I have Problem following


FROM "MIS_DataLake_UAT".dbo."SAP_COST"

where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),

where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),

where "S_REF_KEY_1" <> ('OIL'),

where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);

Problem

incorect syntax near ','.