topic Re: How to Split Field in QlikView

How to Split Field

debabrata_sahoo — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to Split Field

raman_rastogi — Mon, 25 Mar 2019 12:05:16 GMT

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

Re: How to Split Field

Shubham_Deshmukh — Mon, 25 Mar 2019 12:09:55 GMT

Use resident table and create fields like this,

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

Re: How to Split Field

debabrata_sahoo — Mon, 25 Mar 2019 12:14:25 GMT

Thank You @raman_rastogi

Can we have any other way. ?

Re: How to Split Field

Shubham_Deshmukh — Mon, 25 Mar 2019 12:25:02 GMT

Hi,
May I know why you want other way? Means any specific requirement?

Re: How to Split Field

debabrata_sahoo — Mon, 25 Mar 2019 12:31:36 GMT

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.

Re: How to Split Field

Shubham_Deshmukh — Mon, 25 Mar 2019 13:28:20 GMT

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

Re: How to Split Field

debabrata_sahoo — Mon, 25 Mar 2019 13:34:56 GMT

@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.

Re: How to Split Field

Shubham_Deshmukh — Mon, 25 Mar 2019 14:01:15 GMT

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().