Transforming data from an Array into QV

Sunil_Kenth — Tue, 23 Jul 2013 21:19:55 GMT

Hi,

I have a challenge whereby one of the fields in my table is an array and I need to transform this array into separate rows of data. The Challenge I have is that the table contains two types of ID’s; PersonID and AssetID, therefore using something like Subfield() doesn’t work for me.

If you look at the example application attached, you will see there is a field called ‘customers_shared:hierarchy_members’, this field contains values of PersonID’s and AssetID’s for each Hierarchy_ID that I need to extract. If you look closer at this field, in some instances, both PersonID’s and AssetID’s are on the same row (see example bookmark).

How can I transform this array so that I get separate fields and rows for each PersonID and AssetID?

Many thanks in advance for your help on this.

Kind regards,

Sunil

Re: Transforming data from an Array into QV

Sokkorn — Wed, 24 Jul 2013 02:20:16 GMT

Hi Sunil,

Can you attached your QVD file?

Regards,

Sokkorn

Re: Transforming data from an Array into QV

Sunil_Kenth — Wed, 24 Jul 2013 06:43:35 GMT

Hi Sokkom,

The QVD files are now uploaded,

Thanks,

Sunil

topic Transforming data from an Array into QV in QlikView

Transforming data from an Array into QV

Re: Transforming data from an Array into QV

Re: Transforming data from an Array into QV