How to display next 10 numbers?

[thippeshaj]

Hi Splunkers,

Here I'm asking help on Splunk query.

I have a csv file with some numbers between 101-999, I need to write a Splunk query that provides the 10 numbers that are not in the csv.
For example CSV has 198,101,145,223.555,336,987,135,573 and now my splunk query needs to suggest 10 numbers which are not there in the csv.

Thank you in advance.

[yuanliu · Accepted solution]

Something like

| inputlookup myCSV.csv
| stats values(number) as number
| eval range = mvrange(min(number), max(number))
| eval missing = mvmap(range, mvappend(missing, if(range IN (number), null(), range)))
| eval next10 = mvindex(missing, 0, 9)

[thippeshaj]

Thank you.