Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
taxonomy | machine type |
coffee machine-steel case-manual | manual |
tea machine-cup warmer-steel case-automatic | automatic |
coffee/tea machine-one touch-cup warmer-automatic | automatic |
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
Try -1
Thanks