Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Help..

Hi,

Type

A00E

A001

A009

M00E

K009

M09E

How to exclude ending with E
O/p would be

Type

A001

A009

K009

3 Replies
datanibbler
Champion
Champion

Hi Paul,

have a look at String-functions - in particular, LEFT(), RIGHT(), MID()

HTH

Best regards,

DataNibbler

Nicole-Smith

Type:

LOAD * INLINE [

Type

A00E

A001

A009

M00E

K009

M09E

]

where right(Type,1) <> 'E';

qv_testing
Specialist II
Specialist II

You can use where condition

like this

where right(Type,1) <> 'E';