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
