Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
cDS03900
Contributor
Contributor

Filter table on first character being a letter

I have a table with all articles in it. Due to historical reason parts start with a letter, consumables with a digit. 

I now want too filter for further calculations with a button all parts, so articles starting with a letter out of this table.

I have for the moment no clue how to do this, in Excel I would simply write "> a"

1 Solution

Accepted Solutions
Taoufiq_Zarra

OK

Data:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]where IsText(left(Article,1));

 

add where IsText(left(Article,1))

 

output :

Taoufiq_ZARRA_0-1592999213232.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

5 Replies
Taoufiq_Zarra

can you share a sample Data with the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
cDS03900
Contributor
Contributor
Author

I added a screenshot of a sample table how it looks and how it would need to look after filtering.

 

Taoufiq_Zarra

OK

Data:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]where IsText(left(Article,1));

 

add where IsText(left(Article,1))

 

output :

Taoufiq_ZARRA_0-1592999213232.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Saravanan_Desingh

One more solution.

tab1:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]
Where Not IsNum(Left(Article,1));
Saravanan_Desingh

One more version.

tab1:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]
Where Lower(Left(Article,1))<>Upper(Left(Article,1));