topic Re: Split Cells in Qlikview load in QlikView

Split Cells in Qlikview load

Muthu — Wed, 15 Jun 2016 05:10:03 GMT

Hi i have a field with the values in the below format

15-14-2

12-1-15

1-2-3

I have to separate it into 3 columns like

Please help

tamilarasu — Wed, 15 Jun 2016 05:12:49 GMT

Try like below,

Load *,

SubField(FieldName,'-',1) as [Column 1],

SubField(FieldName,'-',2) as [Column 2],

SubField(FieldName,'-',3) as [Column 3]

From Source

elakkians — Wed, 15 Jun 2016 05:34:13 GMT

Try this,

Load,

Subfield(Field,'-',1) as Column1,

Subfield(Field,'-',2) as Column2,

Subfield(Field,'-',3) as Column3

From Data;

avinashelite — Wed, 15 Jun 2016 05:41:11 GMT

If you want to split it as only 3 columns then use

subfield(FieldName,'-',n) as new_filed_name