Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

Split Cells in Qlikview load

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


 

Column 1Column 2Column 3
15142
12115
123

Please help

1 Solution

Accepted Solutions

Re: Split Cells in Qlikview load

Try like below,

Load *,

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

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

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

From Source

3 Replies

Re: Split Cells in Qlikview load

Try like below,

Load *,

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

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

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

From Source

Highlighted
Partner
Partner

Re: Split Cells in Qlikview load

Try this,

Load,

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

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

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

From Data;

Re: Split Cells in Qlikview load

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

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