https://community.qlik.com/t5/Talend-Data-Catalog/Json-File-Output-Excel/m-p/2330542#M907 <P>I have json File input and i do this&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 774px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaKE.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154819i4D95B6D5B033446D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaKE.png" alt="0683p000009MaKE.png" /></span></SPAN></P> <P>output the column eventMetaData contains many columns example like this:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captre.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaKJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141888i9FBD6672454B6A0E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaKJ.png" alt="0683p000009MaKJ.png" /></span></SPAN></P> <P>I want this columns in other row and under column eventMetaData</P> <P>&nbsp;</P> <P>I am running 7.0.1.20180411_1414 Community Version.</P> <P>&nbsp;</P> <P>Thank you for any advice.</P> <P>&nbsp;</P> Sat, 16 Nov 2024 02:18:05 GMT Anonymous 2024-11-16T02:18:05Z https://community.qlik.com/t5/Talend-Data-Catalog/Json-File-Output-Excel/m-p/2330542#M907 <P>I have json File input and i do this&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 774px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaKE.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154819i4D95B6D5B033446D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaKE.png" alt="0683p000009MaKE.png" /></span></SPAN></P> <P>output the column eventMetaData contains many columns example like this:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captre.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaKJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141888i9FBD6672454B6A0E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaKJ.png" alt="0683p000009MaKJ.png" /></span></SPAN></P> <P>I want this columns in other row and under column eventMetaData</P> <P>&nbsp;</P> <P>I am running 7.0.1.20180411_1414 Community Version.</P> <P>&nbsp;</P> <P>Thank you for any advice.</P> <P>&nbsp;</P> Sat, 16 Nov 2024 02:18:05 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Json-File-Output-Excel/m-p/2330542#M907 Anonymous 2024-11-16T02:18:05Z https://community.qlik.com/t5/Talend-Data-Catalog/Json-File-Output-Excel/m-p/2330543#M908 Hi <BR />Sorry, I can't understand your question well, can you show an example to explain what are your expected output? <BR /> <BR />Regards <BR />Shong <BR /> <BR /> Sun, 31 May 2020 02:52:05 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Json-File-Output-Excel/m-p/2330543#M908 Anonymous 2020-05-31T02:52:05Z