topic Re: how to Transpose the column? in QlikView https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244945#M856562 <HTML><HEAD></HEAD><BODY><P>Click on ur question once and see the options </P></BODY></HTML> Wed, 15 Feb 2017 06:05:31 GMT 2017-02-15T06:05:31Z how to Transpose the column? https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244939#M856556 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I&nbsp; have&nbsp; table that consist two columns</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A,B,C</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D,E,F</P><P></P><P>From above table I need output like below</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field2</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; F</P><P></P><P>Thanking you,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244939#M856556 Akina0929 2020-11-25T16:16:04Z Re: how to Transpose the column? https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244940#M856557 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-size: 10.0pt; font-family: 'inherit',serif;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(field2, ',') as field2</STRONG></SPAN></P></BODY></HTML> Thu, 09 Feb 2017 14:49:44 GMT https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244940#M856557 Anonymous 2017-02-09T14:49:44Z Re: how to Transpose the column? https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244941#M856558 <HTML><HEAD></HEAD><BODY><P>These is a similar example available in help:</P><P></P><P><A href="https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm" title="https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm">https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm</A>‌</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152641_Capture.PNG" style="height: 390px; width: 620px;" /></P></BODY></HTML> Thu, 09 Feb 2017 14:51:43 GMT https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244941#M856558 sunny_talwar 2017-02-09T14:51:43Z Re: how to Transpose the column? https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244942#M856559 <HTML><HEAD></HEAD><BODY><P>Thank you,</P><P>&nbsp; got it</P></BODY></HTML> Thu, 09 Feb 2017 15:22:13 GMT https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244942#M856559 Akina0929 2017-02-09T15:22:13Z Re: how to Transpose the column? https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244943#M856560 <HTML><HEAD></HEAD><BODY><P>please close the query (discussion ) by clicking on "answered "</P></BODY></HTML> Tue, 14 Feb 2017 13:26:57 GMT https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244943#M856560 Anonymous 2017-02-14T13:26:57Z Re: how to Transpose the column? https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244944#M856561 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp; Where is that option "answered",sorry I didn't find.</P><P>Thanking you,</P></BODY></HTML> Wed, 15 Feb 2017 05:34:17 GMT https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244944#M856561 Akina0929 2017-02-15T05:34:17Z Re: how to Transpose the column? https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244945#M856562 <HTML><HEAD></HEAD><BODY><P>Click on ur question once and see the options </P></BODY></HTML> Wed, 15 Feb 2017 06:05:31 GMT https://community.qlik.com/t5/QlikView/how-to-Transpose-the-column/m-p/1244945#M856562 2017-02-15T06:05:31Z