topic Re: AutoGenerate in nested Load in QlikView https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519404#M193977 <HTML><HEAD></HEAD><BODY><P>I don't understand your point.</P></BODY></HTML> Tue, 03 Dec 2013 07:47:10 GMT 2013-12-03T07:47:10Z AutoGenerate in nested Load https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519402#M193975 <HTML><HEAD></HEAD><BODY><P>Can someone explain why this statement:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13860560677857691" jivemacro_uid="_13860560677857691"> <P>load</P> <P>&nbsp; a;</P> <P>load</P> <P>&nbsp; RowNo() as a</P> <P>AutoGenerate(10);</P> </PRE><P>behave like this:</P><P><IMG alt="load.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/49870_load.JPG.jpg" /></P><P>?</P></BODY></HTML> Tue, 03 Dec 2013 07:37:04 GMT https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519402#M193975 2013-12-03T07:37:04Z Re: AutoGenerate in nested Load https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519403#M193976 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA... </P></BODY></HTML> Tue, 03 Dec 2013 07:44:02 GMT https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519403#M193976 2013-12-03T07:44:02Z Re: AutoGenerate in nested Load https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519404#M193977 <HTML><HEAD></HEAD><BODY><P>I don't understand your point.</P></BODY></HTML> Tue, 03 Dec 2013 07:47:10 GMT https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519404#M193977 2013-12-03T07:47:10Z Re: AutoGenerate in nested Load https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519405#M193978 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Yo<SPAN style="font-size: 10pt; line-height: 1.5em;">u may use RecNo() instead RowNo()</SPAN></P><P></P><P></P><P>Load </P><P>A</P><P>;</P><P>LOAD</P><P>RecNo() as A</P><P>autogenerate(10);</P><P></P><P>Regards</P></BODY></HTML> Tue, 03 Dec 2013 07:54:06 GMT https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519405#M193978 arbernardez_old 2013-12-03T07:54:06Z Re: AutoGenerate in nested Load https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519406#M193979 <HTML><HEAD></HEAD><BODY><P>Thanks. Now i see what is wrong hire.</P></BODY></HTML> Tue, 03 Dec 2013 07:57:14 GMT https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519406#M193979 2013-12-03T07:57:14Z Re: AutoGenerate in nested Load https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519407#M193980 <HTML><HEAD></HEAD><BODY><P>See my script</P><P></P><P>A:</P><P>LOAD * Inline [</P><P>A,Name,Sales</P><P>1,Nirmal,1000</P><P>];</P><P></P><P></P><P>LOAD</P><P>RecNo() as A</P><P>autogenerate(10);</P></BODY></HTML> Tue, 03 Dec 2013 08:23:54 GMT https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519407#M193980 2013-12-03T08:23:54Z Re: AutoGenerate in nested Load https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519408#M193981 <HTML><HEAD></HEAD><BODY><P>RowNo() is only defined in the topmost Load statement. So, either you move your RowNo() to this Load, or you use the RecNo() function instead.</P><P></P><P>HIC</P></BODY></HTML> Tue, 03 Dec 2013 08:27:37 GMT https://community.qlik.com/t5/QlikView/AutoGenerate-in-nested-Load/m-p/519408#M193981 hic 2013-12-03T08:27:37Z