https://community.qlik.com/t5/Talend-Studio/Extract-header-JSON-and-make-it-dyanamic/m-p/2238697#M26726 <P>Hi Team,</P> <P>We wanted to extract the Key (Header), data level information from the Input JSON file and make it dynamic. Please help for the same if anyone has idea about this.</P> <P>Sample data as below.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Input Json.PNG" style="width: 556px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6fU.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133811iC8FEE99694B74F74/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6fU.png" alt="0683p000009M6fU.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Header(Key) Output:<BR />id;type;name;ppu;batters_batter_id;batters_batter_type;topping_id;topping_type</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Output_data.PNG" style="width: 614px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6fZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147899i797A957D31EAA6C2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6fZ.png" alt="0683p000009M6fZ.png" /></span></SPAN></P> Fri, 19 Jul 2019 12:59:58 GMT Anonymous 2019-07-19T12:59:58Z https://community.qlik.com/t5/Talend-Studio/Extract-header-JSON-and-make-it-dyanamic/m-p/2238697#M26726 <P>Hi Team,</P> <P>We wanted to extract the Key (Header), data level information from the Input JSON file and make it dynamic. Please help for the same if anyone has idea about this.</P> <P>Sample data as below.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Input Json.PNG" style="width: 556px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6fU.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133811iC8FEE99694B74F74/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6fU.png" alt="0683p000009M6fU.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Header(Key) Output:<BR />id;type;name;ppu;batters_batter_id;batters_batter_type;topping_id;topping_type</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Output_data.PNG" style="width: 614px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6fZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147899i797A957D31EAA6C2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6fZ.png" alt="0683p000009M6fZ.png" /></span></SPAN></P> Fri, 19 Jul 2019 12:59:58 GMT https://community.qlik.com/t5/Talend-Studio/Extract-header-JSON-and-make-it-dyanamic/m-p/2238697#M26726 Anonymous 2019-07-19T12:59:58Z https://community.qlik.com/t5/Talend-Studio/Extract-header-JSON-and-make-it-dyanamic/m-p/2238698#M26727 <P>Hello,</P> <P>Please have a look at this component tExtractJSONFields.</P> <P><A title="https://help.talend.com/reader/LNO9Tqm8svZQklRyXL8OYw/~IUSc0SRE4Z8NydlGOcBig" href="https://help.talend.com/reader/LNO9Tqm8svZQklRyXL8OYw/~IUSc0SRE4Z8NydlGOcBig" target="_self" rel="nofollow noopener noreferrer">https://help.talend.com/reader/LNO9Tqm8svZQklRyXL8OYw/~IUSc0SRE4Z8NydlGOcBig</A></P> <P>Best regards</P> <P>Sabrina</P> Mon, 12 Aug 2019 08:37:57 GMT https://community.qlik.com/t5/Talend-Studio/Extract-header-JSON-and-make-it-dyanamic/m-p/2238698#M26727 Anonymous 2019-08-12T08:37:57Z