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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

How to merge a nested object with its parent object

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Madhushree_BP
Support
Support

How to merge a nested object with its parent object

Last Update:

Jul 29, 2021 9:23:54 AM

Updated By:

Jamie_Gregory

Created date:

May 18, 2021 7:44:21 AM

When we have a nested object that needs to be merged with the parent object we can use the formula given below.

In this example, "custom_properties" is the parent object and "properties" is the nested object where we need to merge the "properties" object with its parent object that is "custom_properties".

Madhushree_BP_2-1621234081855.png

Soultion:  We can use the formula {substr: {json: {$.nested_object_name}}, 1, -1}

For the above example we use {substr: {json: {$.properties}}, 1, -1} which will merge the "properties"(nested object) with it's "custom_properties"(parent object).

After using the formula:               

Madhushree_BP_1-1621234005907.png

 

 

                                                       

Tags (1)
Version history
Last update:
‎2021-07-29 09:23 AM
Updated by: