Finding missing values in a sequence

Finding missing values in a sequence

Hi all,I have a sequence of numbers, there are some repeated values (which are fine) and some missing valuesIncomplete Sequence (e.g.)123566910Is there an easy way in Talend that I can extract the values that are missing. So in the above example I need the values of 4, 7 and 8.I am working on a mathematical solution (joining it with a complete sequence, finding the differences, then the differences of the differences) at the moment, but it seems quite a contrived way to do it, is there an easier way?? It needs to be able to deal with the duplicate values, and more than 1 missing value in a row.Thanks in advance,Nilan