topic Re: split string into separate fields in QlikView

split string into separate fields

surajdhall — Wed, 13 Mar 2019 15:49:59 GMT

Hi All,

I have single field in my table and want it into 3 fields. Please note that field3 can have values with pipe sometimes. Please help!

eg-

Field1 Field2 Field3

Asia Oracle HK|YY

//Script

Thanks!

Re: split string into separate fields

tincholiver — Wed, 13 Mar 2019 16:19:39 GMT

Hi, here you have a posible solution:

for this load in your script:

LOAD
Data,
SubField(Data,'|',1) as Field1,
SubField(Data,'|',2) as Field2,
mid(Data,index(Data,'|',2)+1) as Field3

Re: split string into separate fields

surajdhall — Wed, 13 Mar 2019 16:43:24 GMT

Thanks for the quick response.

I see that you have used subfield function. I assume subfield effect the rows of my fact table, i might be wrong.

Can you help me without subfield function?

Re: split string into separate fields

tincholiver — Wed, 13 Mar 2019 17:30:43 GMT

Sorry i dont´know another ay

Re: split string into separate fields

marcus_sommer — Thu, 14 Mar 2019 08:51:59 GMT

The suggestion from tincholiver will work. A subfield() with 3 parameters won't change the number of records - only the version with 2 parameters creates an internal table-loop with additionally records.

- Marcus