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: 
AH
Creator III
Creator III

How to select string values from a field using button?

Hi,

I have a column in a table which is full of strings. what i want to do is, use a part of string(substring) and use that in the search string box and want to select all the values which has that particular substring. Could anyone help me with this? Btw, I was able to achieve that with putting multiple values in searchstring box i.e, like (A|B|C|D). But I want to use substring not the whole.

Capture.PNG.png

I want to take the spare part substring and want to select all the rows which has that particular substring.

Thanks!

Shan

3 Replies
npatel1
Contributor II
Contributor II

Did you get a fix? I have similar query.

BrunPierre
Partner - Master
Partner - Master

In response to @AH inquiry, simply use the below for a search string value.

*spare part*

marcus_sommer

With advanced searches you will be able to select the wanted values but it's not very comfortable for standard-selections. Better will be to apply an appropriate categorizing within the script, for example something like:

pick(wildmatch(upper(Field), '*SPARE PART*', '.....'), 'Spare Stuff', '....') as Category