topic Re: Load where field starts with... in QlikView

Load where field starts with...

Anonymous — Wed, 27 Feb 2013 14:42:44 GMT

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

load,

SQL SELECT *

FROM xxx;

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

and

filed b contain 0000009,00000009,AAA003452,XXX0643

nicolett_yuri — Wed, 27 Feb 2013 14:54:53 GMT

try this

SQL SELECT *

FROM xxx;

where

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

manideep78 — Wed, 27 Feb 2013 15:04:57 GMT

Hi Try this,

LOAD
a,b,c
SQL Select * FROM XXX
WHERE NOT(b LIKE '000*');

Anonymous — Wed, 27 Feb 2013 15:28:29 GMT

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

Anonymous — Wed, 27 Feb 2013 15:37:03 GMT

Am I missing something ???

manideep78 — Wed, 27 Feb 2013 15:43:19 GMT

Use this

WHERE NOT(acno LIKE '000*');

Anonymous — Wed, 27 Feb 2013 16:01:50 GMT

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

Anonymous — Wed, 27 Feb 2013 16:42:12 GMT

Hi Guys,

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

Thanks