topic Re: Help with a data transform in QlikView https://community.qlik.com/t5/QlikView/Help-with-a-data-transform/m-p/811436#M1043223 <HTML><HEAD></HEAD><BODY><P>PFA, I assumed that Qty01 was related to Month01 and so on</P></BODY></HTML> Mon, 24 Nov 2014 21:38:12 GMT jpapador 2014-11-24T21:38:12Z Help with a data transform https://community.qlik.com/t5/QlikView/Help-with-a-data-transform/m-p/811435#M1043222 <HTML><HEAD></HEAD><BODY><P>I have a data set in the format:</P><P>Reference Number, Date01, Date02,...., Date12, Qty01, Qty02,..., Qty12</P><P></P><P>How can I transpose/crosstab this data resulting in:</P><P>Reference Number, Date, Qty</P><P></P><P>Please see attached...</P></BODY></HTML> Mon, 24 Nov 2014 20:47:15 GMT https://community.qlik.com/t5/QlikView/Help-with-a-data-transform/m-p/811435#M1043222 hobanwashburne 2014-11-24T20:47:15Z Re: Help with a data transform https://community.qlik.com/t5/QlikView/Help-with-a-data-transform/m-p/811436#M1043223 <HTML><HEAD></HEAD><BODY><P>PFA, I assumed that Qty01 was related to Month01 and so on</P></BODY></HTML> Mon, 24 Nov 2014 21:38:12 GMT https://community.qlik.com/t5/QlikView/Help-with-a-data-transform/m-p/811436#M1043223 jpapador 2014-11-24T21:38:12Z Re: Help with a data transform https://community.qlik.com/t5/QlikView/Help-with-a-data-transform/m-p/811437#M1043224 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>another solution without hardcoding the field names could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_143402_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/72005_QlikCommunity_Thread_143402_Pic1.JPG.jpg" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14168717947453150" jivemacro_uid="_14168717947453150"> <P>tabInput:</P> <P>CrossTable(ColNam, ColVal)</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; ReferenceNumber, Month01, Month02, Month03, Month04, Month05, Month06, Month07, Month08, Month09, Month10, Month11, Month12, Qty01, Qty02, Qty03, Qty04, Qty05, Qty06, Qty07, Qty08, Qty09, Qty10, Qty11, Qty12</P> <P>&nbsp;&nbsp;&nbsp; Abc01, 1/1/2014, 2/1/2014, 3/1/2014, 4/1/2014, 5/1/2014, 6/1/2014, 7/1/2014, 8/1/2014, 9/1/2014, 10/1/2014, 11/1/2014, 12/1/2014, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0</P> <P>&nbsp;&nbsp;&nbsp; Abc02, 3/1/2014, 4/1/2014, 5/1/2014, 6/1/2014, 7/1/2014, 8/1/2014, 9/1/2014, 10/1/2014, 11/1/2014, 12/1/2014, 1/1/2015, 2/1/2015, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100</P> <P>&nbsp;&nbsp;&nbsp; Abc03, 6/1/2014, 7/1/2014, 8/1/2014, 9/1/2014, 10/1/2014, 11/1/2014, 12/1/2014, 1/1/2015, 2/1/2015, 3/1/2015, 4/1/2015, 5/1/2015, 500, 800, 1000, 1000, 1000, 1000, 1000, 1000, 1000, 1000, 1000, 1000</P> <P>&nbsp;&nbsp;&nbsp; Abc04, 1/1/2014, 2/1/2014, 3/1/2014, 4/1/2014, 5/1/2014, 6/1/2014, 7/1/2014, 8/1/2014, 9/1/2014, 10/1/2014, 11/1/2014, 12/1/2014, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55</P> <P>&nbsp;&nbsp;&nbsp; Abc05, 4/1/2014, 5/1/2014, 6/1/2014, 7/1/2014, 8/1/2014, 9/1/2014, 10/1/2014, 11/1/2014, 12/1/2014, 1/1/2015, 2/1/2015, 3/1/2015, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55</P> <P>];</P> <P></P> <P>tabOutput:</P> <P>Generic LOAD</P> <P>&nbsp; ReferenceNumber,</P> <P>&nbsp; Right(ColNam,2) as ID,</P> <P>&nbsp; Left(ColNam,Len(ColNam)-2),</P> <P>&nbsp; ColVal</P> <P>Resident tabInput;</P> <P></P> <P>DROP Table tabInput;</P> </PRE><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 24 Nov 2014 23:29:39 GMT https://community.qlik.com/t5/QlikView/Help-with-a-data-transform/m-p/811437#M1043224 MarcoWedel 2014-11-24T23:29:39Z