Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil_Kenth
Former Employee
Former Employee

Transforming data from an Array into QV

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

2 Replies
Sokkorn
Master
Master

Hi Sunil,

Can you attached your QVD file?

Regards,

Sokkorn

Sunil_Kenth
Former Employee
Former Employee
Author

Hi Sokkom,

The QVD files are now uploaded,

Thanks,

Sunil