topic Re: Reverse-Crosstable Transformation? in QlikView https://community.qlik.com/t5/QlikView/Reverse-Crosstable-Transformation/m-p/283754#M708339 <HTML><HEAD></HEAD><BODY><P>Nevermind, found it:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/78337#78337">http://community.qlik.com/message/78337#78337</A></P><P></P><P>Alex's solution does exactly what I needed!</P></BODY></HTML> Thu, 22 Sep 2011 21:34:42 GMT 2011-09-22T21:34:42Z Reverse-Crosstable Transformation? https://community.qlik.com/t5/QlikView/Reverse-Crosstable-Transformation/m-p/283753#M708338 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I've got a data set, straight from a quirky source data system, that looks like the result of a crosstable transformation.... but shouldn't.&nbsp; Basically, I have too many rows that should be columns -- so, what should be field names are appearing as row values in single a "Type" column.</P><P></P><P>If the number of Type values were small and static, I'd just do a series of LOAD * WHERE Type =1, 2, 3, etc... and concatenate the tables.&nbsp; However...</P><P></P><P>What's the simplest way to perform a reverse-crosstable transformation?&nbsp; Difficulty is there are also three preceding fields, including identity values, that shouldn't pivot.</P><P></P><P>Thanks,</P><P>DJ</P></BODY></HTML> Thu, 22 Sep 2011 20:59:24 GMT https://community.qlik.com/t5/QlikView/Reverse-Crosstable-Transformation/m-p/283753#M708338 2011-09-22T20:59:24Z Re: Reverse-Crosstable Transformation? https://community.qlik.com/t5/QlikView/Reverse-Crosstable-Transformation/m-p/283754#M708339 <HTML><HEAD></HEAD><BODY><P>Nevermind, found it:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/78337#78337">http://community.qlik.com/message/78337#78337</A></P><P></P><P>Alex's solution does exactly what I needed!</P></BODY></HTML> Thu, 22 Sep 2011 21:34:42 GMT https://community.qlik.com/t5/QlikView/Reverse-Crosstable-Transformation/m-p/283754#M708339 2011-09-22T21:34:42Z