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: 
Sunil_Kenth
Former Employee
Former Employee

Exclude data that contains (C)

Hi,

I would like to exclude data from my data set through the load script where the 'StoreName' contains '(C)' at the beggining.

How can i do this?

Thanks,

Sunil

1 Solution

Accepted Solutions
Sunil_Kenth
Former Employee
Former Employee
Author

Thanks Sunil,  this worked:

where

left(Store_Desc,3)<>'(C)'

and

left(Store_Desc,3)<>'(c)'

Thanks,

Sunil

View solution in original post

3 Replies
SunilChauhan
Champion
Champion

try this

Load

f1

f2

.

.

from path where left(StoreName,1)<>'C';

hope this helps

Sunil Chauhan
Sunil_Kenth
Former Employee
Former Employee
Author

Thanks Sunil,  this worked:

where

left(Store_Desc,3)<>'(C)'

and

left(Store_Desc,3)<>'(c)'

Thanks,

Sunil

SunilChauhan
Champion
Champion

no need to write two times

where

left(upper(Store_Desc),3)<>'(C)';

this will also server the purpose.

Sunil Chauhan