Discussion board where members can get started with QlikView.
I have the attached excel, and I need to get the "Licensed Products for Account" field to show values individually, because now it is one long string.
It is delimited on the | character
I need to do this in the script.
Go to Solution.
Use something like this
LOAD [DMSi Customer ID],
SubField([Licensed Products for Account],'|') as [Licensed Products for Account],
[NPS Owner Date],
[NPS Sys Mgr],
[NPS Sys Mgr Date],
[Type of Site]
(ooxml, embedded labels, table is Export);
I figured it was with subfield. Thanks!