I want to where data

[Anonymous]

Header 1	Header 2	Header 3
Price	Ref.1	Ref.2
500	Oil	-
900	WAG	2
700	WAG	-
800	WAG	3
799	WAG	-

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

EX.

Header 1	Header 2	Header 3
Price	Ref.1	Ref.2
700	WAG	-
900	-	-

[alexpanjhc]

Why 900 is there instead 799?

[Ricardo_Gerhard]

The correct answer should b:

Header 1	Header 2	Header 3
Price	Ref.1	Ref.2
700	WAG	-
799	WAG	-

Could you explain where do you want? Loading statement or graph?

[Anonymous]

Sorry i write wrong

EX. 700 and 799

[Anonymous]

Yes, you are correct.

I want to load data

[Anonymous]

hi, try this

TABLE:

LOAD Price,

     Ref.1,

     Ref.2

FROM

[data.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1)where Ref.1='WAG' AND not Match(Ref.2,2,3);

[Anonymous]

Hi,

Try this.

[Anonymous]

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

[Anonymous]

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 ','.

[Anonymous]

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 ','.