Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You could try the following:
load *, 'Missing ' & subfield(replace(ControlStatus, 'Missing ', ''), ' ') as ControlStatus from Source;
- Marcus
You could try the following:
load *, 'Missing ' & subfield(replace(ControlStatus, 'Missing ', ''), ' ') as ControlStatus from Source;
- Marcus
Yes this worked thank you!! How can I remove lines that have no data in ControlStatus? As now these just have the word Missing in them
Maybe with:
load *, 'Missing ' & subfield(replace(ControlStatus, 'Missing ', ''), ' ') as ControlStatus
from Source where len(trim(ControlStatus));
- Marcus
You have made my day! Thanks so much 🙂