Discussion Board for collaboration on QlikView Scripting.
I am having a field Product Code, Like the one given below.
Now while loading the data. i need to exclude all the codes starting with G.
It should like the following. with out any product codes starting with G.
Go to Solution.
You can try like this also
Where not WildMatch(ProductCode, 'G*');
// In Future, u need to remove any other ProductCode, you can add like this
Where not WildMatch(ProductCode, 'G*' , 'H*');
You can add a where clause at the end of your load statement
where Left(Productcode, 1) <> 'G';
add a where to your load
where not left(Productcode,1)= 'G'
Try to use this.
LOAD * Inline [
where not WildMatch(Productcode, 'G*');