topic Re: Split values in the column in QlikView

Split values in the column

Anonymous — Mon, 10 Aug 2015 06:12:07 GMT

Hi All,

I am having values in the column below format

COLUMN Expected O/P

ABC,DFG,EEE "ABC","DFG",'EEE'

HJK,KK,IPREL, "HJK","KK","IPREL"

GH,IIII,OKPRLAER "GH","IIII","OKPRLAER"

-Jay

Re: Split values in the column

sasiparupudi1 — Mon, 10 Aug 2015 06:16:51 GMT

Use Subfield

Subfield (column,',',1)

Re: Split values in the column

robert_mika — Mon, 10 Aug 2015 06:21:53 GMT

Is your output the same as input just with double quotes after each word?

LOAD

'"'& Replace(Column,',','","')&'"' AS oUTPUT

FROM

(ooxml, embedded labels, table is Sheet1);

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Split values in the column

Mon, 10 Aug 2015 06:29:59 GMT

Hi,

Please find the attached QVW.

Hope it serves the purpose.

Re: Split values in the column

sunny_talwar — Mon, 10 Aug 2015 06:30:38 GMT

May be this:

Table:

LOAD *,

Chr(34) & Replace(COLUMN, ',', Chr(34) & ',' & Chr(34)) & Chr(34) as NEWCOLUMN;

LOAD * Inline [

COLUMN

ABC,DFG,EEE

HJK,KK,IPREL

GH,IIII,OKPRLAER

] (delimiter is |);

Output:

Re: Split values in the column

Anonymous — Mon, 10 Aug 2015 06:38:16 GMT

yeah, it should be with " "

-Jay

Re: Split values in the column

MayilVahanan — Mon, 10 Aug 2015 06:48:39 GMT

Try like this

Table:

LOAD *,

'"' & Replace(COLUMN, ',', '"' & ',' & '"') & '"' as NEWCOLUMN;

LOAD * Inline [

COLUMN

ABC,DFG,EEE

HJK,KK,IPREL

GH,IIII,OKPRLAER

](delimiter is |);

Re: Split values in the column

Mon, 10 Aug 2015 06:56:21 GMT

Try this one Table: LOAD *, ""& Replace(Column,',','","')&'"' AS Ouput; LOAD * Inline [ Column ABC,DFG,EEE HJK,KK,IPREL GH,IIII,OKPRLAER ] ;

Re: Split values in the column

qlikviewwizard — Tue, 11 Aug 2015 02:13:42 GMT

Did you get the solution?