Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
nicolett_yuri

try this

SQL SELECT *

FROM xxx;

where

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

manideep78
Partner - Specialist
Partner - Specialist

Hi Try this,

LOAD

a,b,c

SQL Select * FROM XXX

WHERE NOT(b LIKE '000*');

Anonymous
Not applicable
Author

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
Not applicable
Author

Am I missing something ???

syntax error.PNG

manideep78
Partner - Specialist
Partner - Specialist

Use this

WHERE NOT(acno LIKE '000*');

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi Guys,

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

Thanks