find missing number in list

Wed, 25 Sep 2013 15:31:54 GMT

Hi!

i am having difficulty with finding missing numbers in a list.

for example i have Article Numbers starting with 80000.

i wish to find the missing numbers between 80000 and 80999;

i have tried using the following if statement in script without success.

If(RowNo()<>Artikelnr, RowNo()) as Missing,

Best,

Bradley

Re: find missing number in list

swuehl — Wed, 25 Sep 2013 15:45:35 GMT

Add this to your load script:

LOAD recno()+79999 as MissingID

Autogenerate 1000

where not exists(Artikelnr,recno()+79999);