Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Muthu
Partner - Creator III
Partner - Creator III

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
tamilarasu
Champion
Champion

Try like below,

Load *,

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

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

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

From Source

View solution in original post

3 Replies
tamilarasu
Champion
Champion

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
Partner - Contributor III
Partner - Contributor III

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