https://community.qlik.com/t5/Talend-Studio/Merge-multiple-rows-with-different-field-values-into-one-row/m-p/2268871#M47301 Hi, I would like to merge two rows into one from the same source csv file <BR /> <PRE> ????????????????????????????????????????????????????<BR /> ? id ? date ? uid ? source ? pageviews ?<BR /> ????????????????????????????????????????????????????<BR /> ? 1 ? 2013-12-11 ? 111 ? source1 ? 14 ?<BR /> ? 3 ? 2013-12-11 ? 111 ? source1a ? 1 ?<BR /> ? 11 ? 2013-12-11 ? 222 ? source1 ? 3 ?<BR /> ? 19 ? 2013-12-11 ? 222 ? source1a ? 11 ?<BR /> ????????????????????????????????????????????????????</PRE> <BR />Would become: <BR /> <PRE> ???????????????????????????????????????????????????<BR /> ? id ? date ? uid ? source ? pageviews ?<BR /> ???????????????????????????????????????????????????<BR /> ? 1 ? 2013-12-11 ? 111 ? source1 ? 15 ?<BR /> ? 2 ? 2013-12-11 ? 222 ? source1 ? 14 ?<BR /> ???????????????????????????????????????????????????</PRE> <BR />I would drop the old id column most likely, it's not important <BR />Thank You <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> Sat, 16 Nov 2024 11:47:47 GMT Anonymous 2024-11-16T11:47:47Z https://community.qlik.com/t5/Talend-Studio/Merge-multiple-rows-with-different-field-values-into-one-row/m-p/2268871#M47301 Hi, I would like to merge two rows into one from the same source csv file <BR /> <PRE> ????????????????????????????????????????????????????<BR /> ? id ? date ? uid ? source ? pageviews ?<BR /> ????????????????????????????????????????????????????<BR /> ? 1 ? 2013-12-11 ? 111 ? source1 ? 14 ?<BR /> ? 3 ? 2013-12-11 ? 111 ? source1a ? 1 ?<BR /> ? 11 ? 2013-12-11 ? 222 ? source1 ? 3 ?<BR /> ? 19 ? 2013-12-11 ? 222 ? source1a ? 11 ?<BR /> ????????????????????????????????????????????????????</PRE> <BR />Would become: <BR /> <PRE> ???????????????????????????????????????????????????<BR /> ? id ? date ? uid ? source ? pageviews ?<BR /> ???????????????????????????????????????????????????<BR /> ? 1 ? 2013-12-11 ? 111 ? source1 ? 15 ?<BR /> ? 2 ? 2013-12-11 ? 222 ? source1 ? 14 ?<BR /> ???????????????????????????????????????????????????</PRE> <BR />I would drop the old id column most likely, it's not important <BR />Thank You <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> Sat, 16 Nov 2024 11:47:47 GMT https://community.qlik.com/t5/Talend-Studio/Merge-multiple-rows-with-different-field-values-into-one-row/m-p/2268871#M47301 Anonymous 2024-11-16T11:47:47Z https://community.qlik.com/t5/Talend-Studio/Merge-multiple-rows-with-different-field-values-into-one-row/m-p/2268872#M47302 Hi, <BR />Please take a look at <A href="https://help.talend.com/search/all?query=tAggregateRow&amp;content-lang=en" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:tAggregateRow</A>.<BR />Best regards<BR />Sabrina Tue, 24 Dec 2013 06:06:14 GMT https://community.qlik.com/t5/Talend-Studio/Merge-multiple-rows-with-different-field-values-into-one-row/m-p/2268872#M47302 Anonymous 2013-12-24T06:06:14Z