Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Split column in Excel on | delimiter

Hi.

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.

Any ideas?

1 Solution

Accepted Solutions
Partner
Partner

Re: Split column in Excel on | delimiter

Hi Aaron,

Use something like this

data:

LOAD [DMSi Customer ID],

     SubField([Licensed Products for Account],'|') as [Licensed Products for Account],

     [NPS Owner],

     [NPS Owner Date],

     [NPS Sys Mgr],

     [NPS Sys Mgr Date],

     [Type of Site]

FROM

(ooxml, embedded labels, table is Export);


Felipe.

2 Replies
Partner
Partner

Re: Split column in Excel on | delimiter

Hi Aaron,

Use something like this

data:

LOAD [DMSi Customer ID],

     SubField([Licensed Products for Account],'|') as [Licensed Products for Account],

     [NPS Owner],

     [NPS Owner Date],

     [NPS Sys Mgr],

     [NPS Sys Mgr Date],

     [Type of Site]

FROM

(ooxml, embedded labels, table is Export);


Felipe.

Not applicable

Re: Split column in Excel on | delimiter

I figured it was with subfield. Thanks!