HI I have a data set related to orders , need to identify the missing order numbers,only trouble is my input have some data with repeated numbers input order Number1523401115234012152340131523401315234015152340161523401715234019152340201523402515234026152340271523403115234031152340321523403315234034 Output order Number1523401115234012152340131523401315234014152340151523401615234017152340191523402015234021152340221523402215234023152340241523402515234026152340271523402815234029152340301523403115234031152340321523403315234034 Thanks

identifying the missing values from a sequence of numbers.

I have a data set related to orders , need to identify the missing order numbers,only trouble is my input have some data with repeated numbers

input

order Number
15234011
15234012
15234013
15234013
15234015
15234016
15234017
15234019
15234020
15234025
15234026
15234027
15234031
15234031
15234032
15234033
15234034

Output

order Number
15234011
15234012
15234013
15234013
15234014
15234015
15234016
15234017
15234019
15234020
15234021
15234022
15234022
15234023
15234024
15234025
15234026
15234027
15234028
15234029
15234030
15234031
15234031
15234032
15234033
15234034

Thanks

Transformation

Preparation

Accepted answers

MarqueeCrew

Terse response:

Summarize data get min and max order numbers.

Feed output to generate records and configure start as min and formula to rownum <= max.

You can join this data to the original data.
Use the left input for the original data and the output from the right anchor are the missing orders.

Cheers,

Mark