Discussion Board for collaboration on QlikView Scripting.
Hi all wizards,
Client have a table looking like this:
AAA, BB, CCC, DDDD, EE
AAA, CCC, DDDD, EE
CCC, DDDD, EE
AAA, DDDD, EE
AAA, BB, CCC, DDDD
I need to capture DDDD, but it moves all the time as a result of bad input in underlying systems. Which string function can I use to do this?
Can't use Right or Left, Subfield or FindOneOf (as it's not a string) - so what have I left, or am I missing something...
Torbjörn Ungvall (@Ungvall)
Senior Business Discovery Manager
Go to Solution.
You could use Index().
I made a small exemple for you.
Edit: changed to qvw
You'll first have to append the fields together. After that you can use wildmatch or substringcount:
substringcount(Field1&Field2&Field3&Field4&Field5,'DDDD') as DDDD_Match