find missing number in list

[#1]

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

[swuehl · Accepted solution]

Add this to your load script:

LOAD recno()+79999 as MissingID

Autogenerate 1000

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