Discussion Board for collaboration on QlikView Scripting.
Hi any help with the syntax base on the where clause beased on the idea below
SQL SELECT *
where field b starts which all records beginning with the numeric ' 000';
filed b contain 0000009,00000009,AAA003452,XXX0643
WILDMATCH(b, '000*', '0000009','00000009','AAA003452','XXX0643')>0;
Hi Try this,
LOADa,b,cSQL Select * FROM XXXWHERE NOT(b LIKE '000*');
SQL Select * FROM XXX
WHERE NOT(b LIKE '000*');
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.
Am I missing something ???
WHERE NOT(acno LIKE '000*');
Okay the acro field either numeric or alpha numeric records, Now how do i distinguish the two when loading???
where not left(acno, 1) ='0'; working fine as i can sort out the numeric from the alpha numeric records