Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I need to generate field / table with sequential numbers from X to Y (where X and Y are two variables such as X=666 and Y=2121) .
What's the easiest way to do this?
My end goal is to join another table to this so I can easily see where a record is missing, as I'll have data with records from 666 to 2121 for example but some will be missing... by joining the two I'll be easily able to filter the "missing" records so I can go away and look as to why they are not there.
Hi,
Load
RecNo() + $(X) -1 as field
AutoGenerate ($(Y) - $(X) +1)
;
Hi,
Load
RecNo() + $(X) -1 as field
AutoGenerate ($(Y) - $(X) +1)
;