topic Re: Convert values from column to row in App Development https://community.qlik.com/t5/App-Development/Convert-values-from-column-to-row/m-p/1673315#M51017 <P>Yup - the 2 parameter version of SubField():</P><P>LOAD ID,<BR /><EM>SubField(Business, ',') as Business</EM><BR /><EM>FROM ....</EM></P> Fri, 07 Feb 2020 11:10:00 GMT jonathandienst 2020-02-07T11:10:00Z Convert values from column to row https://community.qlik.com/t5/App-Development/Convert-values-from-column-to-row/m-p/1673299#M51015 <P>Hi All,</P><P>I have data like below table,</P><TABLE width="711"><TBODY><TR><TD width="64">ID</TD><TD width="647">Business</TD></TR><TR><TD>15</TD><TD>Commercial Banking,Global Function-Risk (including Compliance),Retail Banking and Wealth Management</TD></TR><TR><TD>26</TD><TD>Commercial Banking,Retail Banking and Wealth Management</TD></TR><TR><TD>43</TD><TD>Global Banking and Markets,Global Functions</TD></TR><TR><TD>46</TD><TD>Global Banking and Markets</TD></TR><TR><TD>49</TD><TD>Global Banking and Markets</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to convert it into below data,</P><TABLE width="711"><TBODY><TR><TD width="64">ID</TD><TD width="647">Business</TD></TR><TR><TD>15</TD><TD>Commercial Banking</TD></TR><TR><TD>15</TD><TD>Global Function-Risk (including Compliance)</TD></TR><TR><TD>15</TD><TD>Retail Banking and Wealth Management</TD></TR><TR><TD>26</TD><TD>Commercial Banking</TD></TR><TR><TD>26</TD><TD>Retail Banking and Wealth Management</TD></TR><TR><TD>43</TD><TD>Global Banking and Markets</TD></TR><TR><TD>43</TD><TD>Global Functions</TD></TR><TR><TD>46</TD><TD>Global Banking and Markets</TD></TR><TR><TD>49</TD><TD>Global Banking and Markets</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can anyone please help.</P> Fri, 07 Feb 2020 10:12:58 GMT https://community.qlik.com/t5/App-Development/Convert-values-from-column-to-row/m-p/1673299#M51015 pranit_somne 2020-02-07T10:12:58Z Re: Convert values from column to row https://community.qlik.com/t5/App-Development/Convert-values-from-column-to-row/m-p/1673302#M51016 <P>&nbsp;</P><P>You can use qlik function Subfield to achieve your requirement.</P><P>link:&nbsp;<A href="https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubField.htm" target="_blank">https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubField.htm</A></P> Fri, 07 Feb 2020 10:27:43 GMT https://community.qlik.com/t5/App-Development/Convert-values-from-column-to-row/m-p/1673302#M51016 jpenuliar 2020-02-07T10:27:43Z Re: Convert values from column to row https://community.qlik.com/t5/App-Development/Convert-values-from-column-to-row/m-p/1673315#M51017 <P>Yup - the 2 parameter version of SubField():</P><P>LOAD ID,<BR /><EM>SubField(Business, ',') as Business</EM><BR /><EM>FROM ....</EM></P> Fri, 07 Feb 2020 11:10:00 GMT https://community.qlik.com/t5/App-Development/Convert-values-from-column-to-row/m-p/1673315#M51017 jonathandienst 2020-02-07T11:10:00Z