Split Cells in Qlikview load

[Muthu]

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 1	Column 2	Column 3
15	14	2
12	1	15
1	2	3

Please help

[tamilarasu · Accepted solution]

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]

Try this,

Load,

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

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

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

From Data;

[avinashelite]

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

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