https://community.qlik.com/t5/Talend-Studio/resolved-Pivot-Table-with-multiple-rows/m-p/2274219#M50964 Get getting started with Talend and looking for a bit of guidance and an approach to do the following...<BR />DB Table Structure<BR />Team | &nbsp;Value | ValueType &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Team &nbsp;| &nbsp;Score1 | Score2 | Score3<BR />1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.2 &nbsp; &nbsp; &nbsp; Score1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.2 &nbsp; &nbsp; &nbsp; &nbsp;3.2 &nbsp; &nbsp; &nbsp; &nbsp;3<BR />1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.2 &nbsp; &nbsp; &nbsp; Score2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.1 &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5<BR />1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Score3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Trying to transform to ---------&gt;&nbsp;<BR />2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1 &nbsp; &nbsp; &nbsp; Score1<BR />2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Score2<BR />2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Score3<BR />Thanks!<BR />D Fri, 14 Nov 2014 20:58:11 GMT _AnonymousUser 2014-11-14T20:58:11Z https://community.qlik.com/t5/Talend-Studio/resolved-Pivot-Table-with-multiple-rows/m-p/2274219#M50964 Get getting started with Talend and looking for a bit of guidance and an approach to do the following...<BR />DB Table Structure<BR />Team | &nbsp;Value | ValueType &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Team &nbsp;| &nbsp;Score1 | Score2 | Score3<BR />1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.2 &nbsp; &nbsp; &nbsp; Score1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.2 &nbsp; &nbsp; &nbsp; &nbsp;3.2 &nbsp; &nbsp; &nbsp; &nbsp;3<BR />1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.2 &nbsp; &nbsp; &nbsp; Score2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.1 &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5<BR />1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Score3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Trying to transform to ---------&gt;&nbsp;<BR />2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1 &nbsp; &nbsp; &nbsp; Score1<BR />2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Score2<BR />2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Score3<BR />Thanks!<BR />D Fri, 14 Nov 2014 20:58:11 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Pivot-Table-with-multiple-rows/m-p/2274219#M50964 _AnonymousUser 2014-11-14T20:58:11Z https://community.qlik.com/t5/Talend-Studio/resolved-Pivot-Table-with-multiple-rows/m-p/2274220#M50965 This is actually pretty easy in Talend -- if you've done it before <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> <BR />To do this kind of pivot, you're going to use two components together: "tDenormalize" and "tExtractDelimitedFields" <BR />the tDenormalize will flatten your original data into two rows -- one for each team. Then we use tExtractDelimitedFields to break the data into the score1..score3 columns. <BR />Please see the screenshots below. Please let us know if you have any more questions, or if this is not clear.&nbsp; <BR /> <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBNY.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153708i9E419D6D638E7476/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBNY.png" alt="0683p000009MBNY.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBZx.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154518i71FE5FD5EC1CF712/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBZx.png" alt="0683p000009MBZx.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBa2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142280iB4B00D06B10DF6E9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBa2.png" alt="0683p000009MBa2.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBIx.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142310iC398DF2D12E0FA6E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBIx.png" alt="0683p000009MBIx.png" /></span> Fri, 14 Nov 2014 21:40:39 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Pivot-Table-with-multiple-rows/m-p/2274220#M50965 Anonymous 2014-11-14T21:40:39Z https://community.qlik.com/t5/Talend-Studio/resolved-Pivot-Table-with-multiple-rows/m-p/2274221#M50966 <P>emang bener ya Talend banyak di pakai untuk Big Data ???</P> Mon, 24 Sep 2018 07:12:17 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Pivot-Table-with-multiple-rows/m-p/2274221#M50966 Anonymous 2018-09-24T07:12:17Z