Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can I get the last value of indent seperated field

Hi Qlik Community,

I want to split a field. I have the following data set:

taxonomy
coffee machine-steel case-manual
tea machine-cup warmer-steel case-automatic
coffee/tea machine-one touch-cup warmer-automatic

How can I get the last value (type of the machine) of the field?

taxonomymachine type
coffee machine-steel case-manualmanual
tea machine-cup warmer-steel case-automaticautomatic
coffee/tea machine-one touch-cup warmer-automaticautomatic

I have try it with the function 'SubField':

SubField(taxonomy, '-' ,?)

? Is there a function as index for the last value, because my separate field has different number of parts.

Have you an idea what can I do or an alternative way to resolve my problem?

Thanks,

Gamze

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

2 Replies
m_woolf
Master II
Master II

Try -1

Anonymous
Not applicable
Author

Thanks