Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adoteykwame
Contributor

Load where field starts with...

Hi any help with the syntax base on the where clause beased on the idea below

load,

a

b

c

SQL SELECT *

FROM xxx;

where field b starts which all records beginning with the numeric  ' 000';

and

filed b contain 0000009,00000009,AAA003452,XXX0643

7 Replies

Re: Load where field starts with...

try this

SQL SELECT *

FROM xxx;

where

WILDMATCH(b, '000*', '0000009','00000009','AAA003452','XXX0643')>0;

manideep78
Valued Contributor

Re: Load where field starts with...

Hi Try this,

LOAD

a,b,c

SQL Select * FROM XXX

WHERE NOT(b LIKE '000*');

adoteykwame
Contributor

Re: Load where field starts with...

I intended for this rather, where b is not like :

"where field b doesnot starts with ' 000';"  essentially i would want this as the resultant eg.

AAA003452

XXX0643

adoteykwame
Contributor

Re: Load where field starts with...

Am I missing something ???

syntax error.PNG

manideep78
Valued Contributor

Re: Load where field starts with...

Use this

WHERE NOT(acno LIKE '000*');

adoteykwame
Contributor

Re: Load where field starts with...

Okay the acro field either numeric or alpha numeric records, Now how do i distinguish the two when loading???

adoteykwame
Contributor

Re: Load where field starts with...

Hi Guys,

where not left(acno, 1) ='0'; working fine as i can sort out the numeric from the alpha numeric records

Thanks

Community Browser