Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
debabrata_sahoo
Contributor III
Contributor III

How to Split Field

Hi Everyone,

Please help me on below example in script level.

 

Source Table - 
ID      HandlingCode
1        FRO,PER,PHC
2        PES,PHC
3        ICE,PER
4        PER
5        EAP,PER

OutPut Table
ID       HandlingCode1        HandlingCode2        HandlingCode3
1                    FRO                               PER                                   PHC
2                    PES                                PHC
3                    ICE                                 PER
4                    PER
5                    EAP                                PER                                    FRO

2 Solutions

Accepted Solutions
raman_rastogi
Partner - Creator III
Partner - Creator III

Use Subfield() function
ex- Load
SubField(HandlingCode,',',1) as HandlingCode1,
SubField(HandlingCode,',',2) as HandlingCode2,
SubField(HandlingCode,',',3) as HandlingCode3
from ..;

View solution in original post

Shubham_Deshmukh
Specialist
Specialist

Use resident table and create fields like this,

Load
subfield(HandlingCode, ',', 1) as HandlingCode1, subfield(HandlingCode, ',', 2) as HandlingCode2,
subfield(HandlingCode, ',', 3) as HandlingCode3 .
.

View solution in original post

8 Replies
raman_rastogi
Partner - Creator III
Partner - Creator III

Use Subfield() function
ex- Load
SubField(HandlingCode,',',1) as HandlingCode1,
SubField(HandlingCode,',',2) as HandlingCode2,
SubField(HandlingCode,',',3) as HandlingCode3
from ..;
Shubham_Deshmukh
Specialist
Specialist

Use resident table and create fields like this,

Load
subfield(HandlingCode, ',', 1) as HandlingCode1, subfield(HandlingCode, ',', 2) as HandlingCode2,
subfield(HandlingCode, ',', 3) as HandlingCode3 .
.
debabrata_sahoo
Contributor III
Contributor III
Author

Thank You @raman_rastogi 

Can we have any other way.  ?

Shubham_Deshmukh
Specialist
Specialist

Hi,
May I know why you want other way? Means any specific requirement?
debabrata_sahoo
Contributor III
Contributor III
Author

Due to Low  performance . I already implemented on my Script but its take bit more time to execute.

Here in my script I used to do for 9 handling code Fields.

Shubham_Deshmukh
Specialist
Specialist

which database you are using? I think, we can also do this in DB script itself.
debabrata_sahoo
Contributor III
Contributor III
Author

@Shubham_Deshmukh 

Sql Server. But here I need to do it in script level. Now I am using these script only, which you provided earlier.

Shubham_Deshmukh
Specialist
Specialist

That's what I am saying, DB has some inbuilt function to do this, now I also don't have exact idea about it but DB has some function like MySQL has Substring_inde().