https://community.qlik.com/t5/QlikView/Automatic-generation-of-serial-Numbers/m-p/1748113#M590519 <P>Good, thank you very much!</P> Tue, 29 Sep 2020 13:20:03 GMT wood 2020-09-29T13:20:03Z https://community.qlik.com/t5/QlikView/Automatic-generation-of-serial-Numbers/m-p/1748089#M590517 <P>&nbsp;</P><P>hi all</P><P>How do You generate field 2 from field 1 in a script</P><P>Filed1, Filed2<BR />A, 1<BR />B ,1<BR />B ,2<BR />C, 1<BR />C, 2<BR />C, 3<BR />D ,1<BR />D ,2</P> Tue, 29 Sep 2020 12:32:35 GMT https://community.qlik.com/t5/QlikView/Automatic-generation-of-serial-Numbers/m-p/1748089#M590517 wood 2020-09-29T12:32:35Z https://community.qlik.com/t5/QlikView/Automatic-generation-of-serial-Numbers/m-p/1748097#M590518 <P>Try this</P><P>LOAD *,<STRONG> AutoNumber(RecNo(), Filed1) as Filed2</STRONG> Inline [<BR />Filed1<BR />A<BR />B&nbsp;<BR />B&nbsp;<BR />C<BR />C<BR />C<BR />D<BR />D<BR />];</P> Tue, 29 Sep 2020 12:49:21 GMT https://community.qlik.com/t5/QlikView/Automatic-generation-of-serial-Numbers/m-p/1748097#M590518 Anil_Babu_Samineni 2020-09-29T12:49:21Z https://community.qlik.com/t5/QlikView/Automatic-generation-of-serial-Numbers/m-p/1748113#M590519 <P>Good, thank you very much!</P> Tue, 29 Sep 2020 13:20:03 GMT https://community.qlik.com/t5/QlikView/Automatic-generation-of-serial-Numbers/m-p/1748113#M590519 wood 2020-09-29T13:20:03Z