topic Script to transform Exceltable with slow moving categories in QlikView https://community.qlik.com/t5/QlikView/Script-to-transform-Exceltable-with-slow-moving-categories/m-p/999735#M339908 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have a inputtable in excel with categories and then datarows below. On each datarow I would like to know the category that the datarow belongs to. Se the pictures as sample input. I also attach a small samplefile in excel. <SPAN style="font-size: 13.3333px;">How can I make the resulttable with script in Qlikview. Any ideas?</SPAN></P><P></P><P><IMG alt="input.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108784_input.png" style="height: auto;" /></P><P><IMG alt="result.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/108785_result.png" style="height: auto;" /></P><P>Best regards</P><P>Peter</P></BODY></HTML> Fri, 11 Dec 2015 16:02:24 GMT Anonymous 2015-12-11T16:02:24Z Script to transform Exceltable with slow moving categories https://community.qlik.com/t5/QlikView/Script-to-transform-Exceltable-with-slow-moving-categories/m-p/999735#M339908 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have a inputtable in excel with categories and then datarows below. On each datarow I would like to know the category that the datarow belongs to. Se the pictures as sample input. I also attach a small samplefile in excel. <SPAN style="font-size: 13.3333px;">How can I make the resulttable with script in Qlikview. Any ideas?</SPAN></P><P></P><P><IMG alt="input.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108784_input.png" style="height: auto;" /></P><P><IMG alt="result.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/108785_result.png" style="height: auto;" /></P><P>Best regards</P><P>Peter</P></BODY></HTML> Fri, 11 Dec 2015 16:02:24 GMT https://community.qlik.com/t5/QlikView/Script-to-transform-Exceltable-with-slow-moving-categories/m-p/999735#M339908 Anonymous 2015-12-11T16:02:24Z Re: Script to transform Exceltable with slow moving categories https://community.qlik.com/t5/QlikView/Script-to-transform-Exceltable-with-slow-moving-categories/m-p/999736#M339909 <HTML><HEAD></HEAD><BODY><P>Perhaps like this:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14498593682764512" jivemacro_uid="_14498593682764512"> <P>Data:</P> <P>LOAD *</P> <P>WHERE Qty &lt;&gt; 'Qty' ;</P> <P>LOAD</P> <P>&nbsp; If(Previous(B)='Qty' ,Previous(A),Peek(Category)) as Category,</P> <P>&nbsp; A as Item,</P> <P>&nbsp; B as Qty,</P> <P>&nbsp; C as Value</P> <P>FROM</P> <P>[Sample_data.xlsx]</P> <P>(ooxml, no labels, table is Input)</P> <P>WHERE Len(Trim(B))&gt;0;</P> </PRE></BODY></HTML> Fri, 11 Dec 2015 18:42:48 GMT https://community.qlik.com/t5/QlikView/Script-to-transform-Exceltable-with-slow-moving-categories/m-p/999736#M339909 Gysbert_Wassenaar 2015-12-11T18:42:48Z Re: Script to transform Exceltable with slow moving categories https://community.qlik.com/t5/QlikView/Script-to-transform-Exceltable-with-slow-moving-categories/m-p/999737#M339910 <HTML><HEAD></HEAD><BODY><P>It's wokring. Thank you Gysbert for the help</P></BODY></HTML> Fri, 11 Dec 2015 19:01:15 GMT https://community.qlik.com/t5/QlikView/Script-to-transform-Exceltable-with-slow-moving-categories/m-p/999737#M339910 Anonymous 2015-12-11T19:01:15Z