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: 
amithmurali
Partner - Creator II
Partner - Creator II

Filter/Exclude Specific Values while loading Data.

Hi guys.

I am having a field Product Code, Like the one given below.

Productcode

A12344
CD1234
QC12345
G1234
GC1234245
RS23434

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.

Productcode
A12344
CD1234
QC12345
RS12234

ZE43321

1 Solution

Accepted Solutions
MayilVahanan

Hi

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*');

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

5 Replies
Ralf-Narfeldt
Employee
Employee

You can add a where clause at the end of your load statement

Load ....

where Left(Productcode, 1) <> 'G';

maxgro
MVP
MVP

add a where to your load

where not left(Productcode,1)= 'G'

qlikmsg4u
Specialist
Specialist

Load

...

Where Left(Productcode,1)<>'G'

senpradip007
Specialist III
Specialist III

Try to use this.

LOAD * Inline [

Productcode

A12344

CD1234

QC12345

G1234

GC1234245

RS23434

]

where not WildMatch(Productcode, 'G*');

MayilVahanan

Hi

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*');

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.