Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

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

Re: Filter/Exclude Specific Values while loading Data.

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

View solution in original post

5 Replies
Employee
Employee

Re: Filter/Exclude Specific Values while loading Data.

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

Load ....

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

MVP
MVP

Re: Filter/Exclude Specific Values while loading Data.

add a where to your load

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

qlikmsg4u
Valued Contributor

Re: Filter/Exclude Specific Values while loading Data.

Load

...

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

senpradip007
Valued Contributor III

Re: Filter/Exclude Specific Values while loading Data.

Try to use this.

LOAD * Inline [

Productcode

A12344

CD1234

QC12345

G1234

GC1234245

RS23434

]

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

Re: Filter/Exclude Specific Values while loading Data.

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

View solution in original post