topic Re: I want where not and where in App Development

I want where not and where

Anonymous — Thu, 20 Sep 2018 16:12:05 GMT

Data

Load

Price,

Ref.1,

Ref.2

SQL

"Price",

"Ref.1",

"Ref.2"

FROM "MIS_DataLake_UAT".dbo."SAP_COST";

where Ref.1='WAG' and not match (Ref.2,2,3)

where Ref.1 not match ('OIL')

EX.

Price	Ref.1	Ref.2
200	OIL	-
300	-	-
400	COST	-
500	WAG	1
600	WAG	2
700	WAG	3
800	WAG	4
900	OIL	1
1000	COST	2

Result

Price	Ref.1	Ref.2
300	-	-
400	COST	-
500	WAG	1
800	WAG	4
1000	COST	2

I write incorrect.

What Should I write ?

Sum({$<[Warehouse.S_TOD] = {'TOD1'}>} and {$<[S_VEND_ID] = {'702'}>} distinct(total))

Sum({$<[Warehouse.S_TOD] = {'TOD1'}>} and {$<[S_VEND_ID] not {'702'}>} distinct(total))

Thank You for answer question.

Re: I want where not and where

Gysbert_Wassenaar — Thu, 20 Sep 2018 16:16:38 GMT

Sum({$<[Warehouse.S_TOD] = {'TOD1'}, [S_VEND_ID] = {'702'}>} Price)

Sum({$<[Warehouse.S_TOD] = {'TOD1'}>,[S_VEND_ID] -= {'702'}>} Price)

Re: I want where not and where

Anonymous — Fri, 21 Sep 2018 03:15:02 GMT

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);

Re: I want where not and where

Anonymous — Fri, 21 Sep 2018 03:22:39 GMT

Problem

Re: I want where not and where

Gysbert_Wassenaar — Sat, 22 Sep 2018 15:42:49 GMT

MS SQL Server doesn't understand the SQL statement you send it. There's a syntax error in it. Most SQL dialects only support one single Where clause. And if you're using multiple conditions you need to use the AND of OR keyword to specify how the conditions should be combined. Try this SQL tutorial: SQL Tutorial

Re: I want where not and where

Anonymous — Mon, 24 Sep 2018 11:25:11 GMT

thank you