<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article How to merge a nested object with its parent object in Official Support Articles</title>
    <link>https://community.qlik.com/t5/Official-Support-Articles/How-to-merge-a-nested-object-with-its-parent-object/ta-p/1808255</link>
    <description>&lt;P&gt;When we have a nested object that needs to be merged with the parent object we can use the formula given below.&lt;/P&gt;
&lt;P&gt;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".&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_2-1621234081855.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/55079i064050C2E2789BCD/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Madhushree_BP_2-1621234081855.png" alt="Madhushree_BP_2-1621234081855.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;Soultion:&amp;nbsp; We can use the formula&amp;nbsp;{substr: {json: {$.nested_object_name}}, 1, -1}&lt;/P&gt;
&lt;P&gt;For the above example we use&amp;nbsp;{substr: {json: {$.properties}}, 1, -1} which will merge the "properties"(nested object) with it's "custom_properties"(parent object).&lt;/P&gt;
&lt;P&gt;After using the formula:&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_1-1621234005907.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/55078iAF5CE26B26385CDE/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Madhushree_BP_1-1621234005907.png" alt="Madhushree_BP_1-1621234005907.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 29 Jul 2021 13:23:54 GMT</pubDate>
    <dc:creator>Madhushree_BP</dc:creator>
    <dc:date>2021-07-29T13:23:54Z</dc:date>
    <item>
      <title>How to merge a nested object with its parent object</title>
      <link>https://community.qlik.com/t5/Official-Support-Articles/How-to-merge-a-nested-object-with-its-parent-object/ta-p/1808255</link>
      <description>&lt;P&gt;When we have a nested object that needs to be merged with the parent object we can use the formula given below.&lt;/P&gt;
&lt;P&gt;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".&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_2-1621234081855.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/55079i064050C2E2789BCD/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Madhushree_BP_2-1621234081855.png" alt="Madhushree_BP_2-1621234081855.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;Soultion:&amp;nbsp; We can use the formula&amp;nbsp;{substr: {json: {$.nested_object_name}}, 1, -1}&lt;/P&gt;
&lt;P&gt;For the above example we use&amp;nbsp;{substr: {json: {$.properties}}, 1, -1} which will merge the "properties"(nested object) with it's "custom_properties"(parent object).&lt;/P&gt;
&lt;P&gt;After using the formula:&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhushree_BP_1-1621234005907.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/55078iAF5CE26B26385CDE/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Madhushree_BP_1-1621234005907.png" alt="Madhushree_BP_1-1621234005907.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 29 Jul 2021 13:23:54 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Official-Support-Articles/How-to-merge-a-nested-object-with-its-parent-object/ta-p/1808255</guid>
      <dc:creator>Madhushree_BP</dc:creator>
      <dc:date>2021-07-29T13:23:54Z</dc:date>
    </item>
  </channel>
</rss>

