Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I got a table with names, lets say:
Adam |
Bert |
Ceasar |
Doris |
Eva |
Additionally I got a dataset which includes one column, where those names are part of, eg.
Column1 | Name Column | Column 3 |
xyz | ENG Adam 135 | qwer |
xyz | FRA Doris 657 | qwer |
xyz | 8945 USA Eva | qwer |
xyz | ENG 23612/Caesar | qwer |
As you can see, the values in the second column aren't always following the same logic, so I can't use Subfield etc.
Is there a way to get to the following outcome:
Column1 | Name | Column3 |
xyz | Adam | qwer |
xyz | Doris | qwer |
xyz | Eva | qwer |
xyz | Caesar | qwer |
Thanks
can you try using Mapsubstring function.
https://community.qlik.com/t5/QlikView-App-Dev/Mapping-of-strings-mapsubstring-replace/m-p/1736142
The first table with the names is a field from another table, so I have to resident load, instead of Inline. Sadly it seems not to work.