topic Autogenerate data in QlikView https://community.qlik.com/t5/QlikView/Autogenerate-data/m-p/168833#M39852 <HTML><HEAD></HEAD><BODY><P>Am not sure, whether all digits and letters are used actually in Holland (adding to some 6 Mio records), but here is goes:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">FOR i=97 TO 122<BR /> Letter:<BR /> LOAD<BR /> CHR($(i)) AS Letter<BR /> AUTOGENERATE<BR /> 1;<BR />NEXT i;<BR /><BR />JOIN (Letter) LOAD Letter AS Letter2 RESIDENT Letter;<BR /><BR />FOR i = 1000 TO 9999<BR /> Digits:<BR /> LOAD<BR /> $(i) AS Digit<BR /> AUTOGENERATE<BR /> 1;<BR />NEXT i;<BR /><BR />DigitLetter:<BR /> JOIN (Digits) LOAD * RESIDENT Letter;<BR /> DROP TABLE Letter;<BR /><BR />ZIP:<BR /> LOAD<BR /> Digit &amp; Letter &amp; Letter2 AS ZIP<BR /> RESIDENT<BR /> Digits;<BR /><BR />DROP TABLE Digits;<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Mon, 30 Nov 2009 19:27:08 GMT prieper 2009-11-30T19:27:08Z Autogenerate data https://community.qlik.com/t5/QlikView/Autogenerate-data/m-p/168832#M39851 <HTML><HEAD></HEAD><BODY><P>I am a newbie in QlikView scripting.</P><P>I want to write a QV-script to autogenerate a postal code QVD file with all possible Dutch postalcodes from 1000aa to 9999zz</P><P>How do I write this in QV script?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 30 Nov 2009 17:56:54 GMT https://community.qlik.com/t5/QlikView/Autogenerate-data/m-p/168832#M39851 2009-11-30T17:56:54Z Autogenerate data https://community.qlik.com/t5/QlikView/Autogenerate-data/m-p/168833#M39852 <HTML><HEAD></HEAD><BODY><P>Am not sure, whether all digits and letters are used actually in Holland (adding to some 6 Mio records), but here is goes:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">FOR i=97 TO 122<BR /> Letter:<BR /> LOAD<BR /> CHR($(i)) AS Letter<BR /> AUTOGENERATE<BR /> 1;<BR />NEXT i;<BR /><BR />JOIN (Letter) LOAD Letter AS Letter2 RESIDENT Letter;<BR /><BR />FOR i = 1000 TO 9999<BR /> Digits:<BR /> LOAD<BR /> $(i) AS Digit<BR /> AUTOGENERATE<BR /> 1;<BR />NEXT i;<BR /><BR />DigitLetter:<BR /> JOIN (Digits) LOAD * RESIDENT Letter;<BR /> DROP TABLE Letter;<BR /><BR />ZIP:<BR /> LOAD<BR /> Digit &amp; Letter &amp; Letter2 AS ZIP<BR /> RESIDENT<BR /> Digits;<BR /><BR />DROP TABLE Digits;<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Mon, 30 Nov 2009 19:27:08 GMT https://community.qlik.com/t5/QlikView/Autogenerate-data/m-p/168833#M39852 prieper 2009-11-30T19:27:08Z