topic Re: combining data in excel sheet in multiple rows into a single row in Talend Studio https://community.qlik.com/t5/Talend-Studio/combining-data-in-excel-sheet-in-multiple-rows-into-a-single-row/m-p/2342938#M110746 <P><A href="https://community.qlik.com/s/profile/0053p000007LOQVAA4">@Chaithra_kb</A>,are you looking for the below one?</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 802px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lyg7.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138009i7386AACA5BBEBAAE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lyg7.png" alt="0683p000009Lyg7.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 791px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LydT.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148800i1582C26A6BA26389/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LydT.png" alt="0683p000009LydT.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 792px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyGz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141655iCD3E32A2F049223A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyGz.png" alt="0683p000009LyGz.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lye2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129506i241E361CB17A12E2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lye2.png" alt="0683p000009Lye2.png" /></span></SPAN></P> Mon, 28 May 2018 11:54:14 GMT manodwhb 2018-05-28T11:54:14Z combining data in excel sheet in multiple rows into a single row https://community.qlik.com/t5/Talend-Studio/combining-data-in-excel-sheet-in-multiple-rows-into-a-single-row/m-p/2342937#M110745 <P>Hello all,</P> <P>I have to build a job where the data is in the excel sheet as follows</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD> <P>id</P> </TD> <TD> <P>vaultstatusaction</P> </TD> </TR> <TR> <TD> <P>OQ3000000000Q42</P> </TD> <TD> <P>Pending FDD Review</P> </TD> </TR> <TR> <TD> <P>OQ3000000000Q43</P> </TD> <TD> <P>Pending FDD Review</P> </TD> </TR> <TR> <TD> <P>OQ3000000000Q44</P> </TD> <TD> <P>Pending FDD Review</P> </TD> </TR> <TR> <TD> <P>OQ3000000000Q45</P> </TD> <TD> <P>Pending FDD Review</P> </TD> </TR> <TR> <TD> <P>OQ3000000000O53</P> </TD> <TD> <P>api/v18.1/vobjects/disclosure__c/OQ3000000000O53/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c</P> </TD> </TR> <TR> <TD> <P>OQ3000000000O54</P> </TD> <TD> <P>api/v18.1/vobjects/disclosure__c/OQ3000000000O54/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c</P> </TD> </TR> <TR> <TD> <P>OQ3000000000O55</P> </TD> <TD> <P>api/v18.1/vobjects/disclosure__c/OQ3000000000O55/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>the output needed is</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD> <P>&nbsp;</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD> <P>url</P> </TD> <TD> <P>idlist</P> </TD> </TR> <TR> <TD> <TABLE> <TBODY> <TR> <TD> <P>api/v18.1/vobjects/disclosure__c/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c "</P> </TD> </TR> <TR> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> </TD> <TD> <P>"id = OQ3000000000Q42,OQ3000000000Q43,OQ3000000000Q45"</P> </TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> <P>so I&nbsp;have to get 100 ids in a single row in the second column separated&nbsp;by a comma. Can anyone help me with this?</P> <P>&nbsp;</P> Thu, 24 May 2018 07:35:37 GMT https://community.qlik.com/t5/Talend-Studio/combining-data-in-excel-sheet-in-multiple-rows-into-a-single-row/m-p/2342937#M110745 Anonymous 2018-05-24T07:35:37Z Re: combining data in excel sheet in multiple rows into a single row https://community.qlik.com/t5/Talend-Studio/combining-data-in-excel-sheet-in-multiple-rows-into-a-single-row/m-p/2342938#M110746 <P><A href="https://community.qlik.com/s/profile/0053p000007LOQVAA4">@Chaithra_kb</A>,are you looking for the below one?</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 802px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lyg7.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138009i7386AACA5BBEBAAE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lyg7.png" alt="0683p000009Lyg7.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 791px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LydT.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148800i1582C26A6BA26389/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LydT.png" alt="0683p000009LydT.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 792px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyGz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141655iCD3E32A2F049223A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyGz.png" alt="0683p000009LyGz.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lye2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129506i241E361CB17A12E2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lye2.png" alt="0683p000009Lye2.png" /></span></SPAN></P> Mon, 28 May 2018 11:54:14 GMT https://community.qlik.com/t5/Talend-Studio/combining-data-in-excel-sheet-in-multiple-rows-into-a-single-row/m-p/2342938#M110746 manodwhb 2018-05-28T11:54:14Z