topic How to split Column info and select only a subset of subfields ? in QlikView

How to split Column info and select only a subset of subfields ?

Tue, 04 Mar 2014 23:05:07 GMT

Hi,

I need to parse a column which has the following format (e-commerce cart)

a:2:{i:0;O:8:"stdClass":20:{s:4:"type";s:8:"activity";s:4:"name";s:32:"The Name of My Service 1";s:7:"complex"}i:1;O:8:"stdClass":20:{s:4:"type";s:8:"activity";s:4:"name";s:32:"The Name of My Service 2";s:7:"paramet"}}

and I want to obtain from it , cart products which in this case they are:

The Name of My Service 1

The Name of My Service 2

and obviously the number of products is not always the same for all carts and even, the number of parameters for each product is not the same ... the only thing we now is that product Name attribute goes always after "name" attribute...

Any hint?

Thanks a lot!!

Re: How to split Column info and select only a subset of subfields ?

maxgro — Tue, 04 Mar 2014 23:32:36 GMT

see attachement

it would be useful to have some more records to check my script

Re: How to split Column info and select only a subset of subfields ?

Wed, 05 Mar 2014 00:04:58 GMT

Thanks a lot!! IT works almost perfect!!

"where id > 1" condition I suppose that it is to remove the first token but it does not work well because my table "cart" has a lot of records and id column is an incremental integer which is only 1 for the first"cart"...

Re: How to split Column info and select only a subset of subfields ?

Wed, 05 Mar 2014 00:09:52 GMT

There is not a way to add a column indicating SubFieldIndex with values 1,..2, nbSubFields? so after this we can filter

SubField(cart,'name') as col1,

SubFieldIndex,

where SubFieldIndex > 1

Re: How to split Column info and select only a subset of subfields ?

Wed, 05 Mar 2014 00:30:04 GMT

If you use this in your w.qvw you will see what I mean

LOAD * INLINE [

col

`'a:2:{i:0;O:8:"stdClass":20:{s:4:"type";s:8:"activity";s:4:"name";s:32:"The Name of My Service 1";s:7:"complex"}i:1;O:8:"stdClass":20:{s:4:"type";s:8:"activity";s:4:"name";s:32:"The Name of My Service 2";s:7:"paramet"}}`

];

Re: Re: How to split Column info and select only a subset of subfields ?

maxgro — Wed, 05 Mar 2014 22:48:47 GMT

hope it helps

added a flag to identify first of every group