topic Re: Split column in Excel on | delimiter in QlikView

Split column in Excel on | delimiter

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Split column in Excel on | delimiter

felipedl — Wed, 05 Jul 2017 19:54:08 GMT

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.

Re: Split column in Excel on | delimiter

Wed, 05 Jul 2017 19:58:27 GMT

I figured it was with subfield. Thanks!