https://community.qlik.com/t5/Talend-Studio/iterate-some-transpositions-from-rows-to-colums/m-p/2353131#M119388 <P>Hello</P><P>I have an excel file which collects answers from a survey.</P><P>the excel has this formay:</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000GgdZDAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154454i153A447D323C95FA/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000GgdZDAAZ.png" alt="0695b00000GgdZDAAZ.png" /></span></P><P></P><P></P><P>I'd like to transform into a file like this</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000GgdakAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140491i57B71EB86A964CE6/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000GgdakAAB.png" alt="0695b00000GgdakAAB.png" /></span></P><P></P><P></P><P>I know the component <B>tPivotToColumnsDelimited</B> but I want the other way.</P><P></P><P></P><P><B>tUnpivotRow </B>: doesnt really work because I want to iterate on a group of columns (i want to ietrate by topic)</P><P></P><P></P><P>can you help me?</P><P></P><P></P><P></P><P></P> Thu, 08 Jul 2021 17:12:54 GMT icad1625763435 2021-07-08T17:12:54Z https://community.qlik.com/t5/Talend-Studio/iterate-some-transpositions-from-rows-to-colums/m-p/2353131#M119388 <P>Hello</P><P>I have an excel file which collects answers from a survey.</P><P>the excel has this formay:</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000GgdZDAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154454i153A447D323C95FA/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000GgdZDAAZ.png" alt="0695b00000GgdZDAAZ.png" /></span></P><P></P><P></P><P>I'd like to transform into a file like this</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000GgdakAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140491i57B71EB86A964CE6/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000GgdakAAB.png" alt="0695b00000GgdakAAB.png" /></span></P><P></P><P></P><P>I know the component <B>tPivotToColumnsDelimited</B> but I want the other way.</P><P></P><P></P><P><B>tUnpivotRow </B>: doesnt really work because I want to iterate on a group of columns (i want to ietrate by topic)</P><P></P><P></P><P>can you help me?</P><P></P><P></P><P></P><P></P> Thu, 08 Jul 2021 17:12:54 GMT https://community.qlik.com/t5/Talend-Studio/iterate-some-transpositions-from-rows-to-colums/m-p/2353131#M119388 icad1625763435 2021-07-08T17:12:54Z https://community.qlik.com/t5/Talend-Studio/iterate-some-transpositions-from-rows-to-colums/m-p/2353132#M119389 <P>hello</P><P>is it possible to do such a thing?</P> Fri, 09 Jul 2021 21:27:07 GMT https://community.qlik.com/t5/Talend-Studio/iterate-some-transpositions-from-rows-to-colums/m-p/2353132#M119389 icad1625763435 2021-07-09T21:27:07Z