Subfield numerous spaces

[khaycock]

Is it possible in QlikView to use Subfield to separate data after a second delimiter? I want to separate out each line where there the word Missing starts? So where it says Missing CYBERARK Missing SCCM, I want them split up to two lines of data.

 

[marcus_malinow]

Hi,

if you just use

Subfield([Your field], ' ') as Newfield

without the index parameter this will split the data across several rows (depending on how many subfields exist in the source field.

Marcus

[felipe87]

Great information! I really need this! I just went back to the help page and now I see it was there all the time.. But your explanation was more clearly and I think that should have an example of this on the help site.