topic Re: How do I convert Columns into Rows? in App Development https://community.qlik.com/t5/App-Development/How-do-I-convert-Columns-into-Rows/m-p/1734060#M56060 <P>Try <A href="https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm" target="_blank" rel="noopener">CrossTable Load</A></P> Fri, 07 Aug 2020 10:50:29 GMT sunny_talwar 2020-08-07T10:50:29Z How do I convert Columns into Rows? https://community.qlik.com/t5/App-Development/How-do-I-convert-Columns-into-Rows/m-p/1734058#M56059 <P>This is my input :</P><P>ID&nbsp; &nbsp; Jan 20&nbsp; &nbsp; &nbsp; Feb 20</P><P>1&nbsp; &nbsp; &nbsp; 1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000</P><P>2&nbsp; &nbsp; &nbsp; 2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000</P><P>&nbsp;</P><P>I am looking to convert this into something like this below:</P><P>ID&nbsp; &nbsp; Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value</P><P>1&nbsp; &nbsp; &nbsp;01/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000</P><P>1&nbsp; &nbsp; &nbsp;02/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2000</P><P>2&nbsp; &nbsp; &nbsp;01/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2000</P><P>2&nbsp; &nbsp; &nbsp; 02/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000</P><P>&nbsp;</P><P>How do I need to script it in Qlik Sense?</P> Sat, 16 Nov 2024 18:15:15 GMT https://community.qlik.com/t5/App-Development/How-do-I-convert-Columns-into-Rows/m-p/1734058#M56059 Naushad07 2024-11-16T18:15:15Z Re: How do I convert Columns into Rows? https://community.qlik.com/t5/App-Development/How-do-I-convert-Columns-into-Rows/m-p/1734060#M56060 <P>Try <A href="https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm" target="_blank" rel="noopener">CrossTable Load</A></P> Fri, 07 Aug 2020 10:50:29 GMT https://community.qlik.com/t5/App-Development/How-do-I-convert-Columns-into-Rows/m-p/1734060#M56060 sunny_talwar 2020-08-07T10:50:29Z Re: How do I convert Columns into Rows? https://community.qlik.com/t5/App-Development/How-do-I-convert-Columns-into-Rows/m-p/1734061#M56061 <P>Here is shows some examples too -&gt;&nbsp;<A href="https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-cross-tables.htm" target="_blank" rel="noopener">Working with crosstables in the data load script</A>&nbsp;</P> Fri, 07 Aug 2020 10:51:29 GMT https://community.qlik.com/t5/App-Development/How-do-I-convert-Columns-into-Rows/m-p/1734061#M56061 sunny_talwar 2020-08-07T10:51:29Z