Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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.

View solution in original post

2 Replies
Partner
Partner

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.

View solution in original post

Not applicable

I figured it was with subfield. Thanks!