Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adoteykwame
Contributor

Load with 2 where clauses

Hi,

Could someone please help me with this syntax i get an error when it executes

LOAD

A,

B'

clicod,

C,

D

SQL SELECT *

FROM PAB

WHERE NOT clicod = 'IN' and WHERE NOT LEFT(clicod,1) = 'B';

2 Replies

Re: Load with 2 where clauses

the second where in unuseful

SQL SELECT *

FROM PAB

WHERE NOT clicod = 'IN' and NOT LEFT(clicod,1) = 'B';

Not applicable

Re: Load with 2 where clauses

SQL SELECT *

FROM PAB

WHERE clicod <> 'IN' and  LEFT(clicod,1) <> 'B';

Community Browser