Hello @thambisetty ,   Can you able to explain each line usage if possible?   How can we build this same missing_number logic in if condition and throw an error if we miss any number in between. In our case also the sequnce increase by one.   Each Doc_ID(AGDGYS8737vdhh = file_name like category mentioned in this post) has set of sequence_number increase one by one.If it not increase by one means then we came to conclusion like some number missed in between we can trigger alert then and there. ... View more

Hello @ITWhisperer & @bowesmana  & @yuanliu ,   Thanks One more question , How Can I put logic to find missing number in this sequence of dynamically changing numbers: It has no logic except it increase one by one. Is there any way to build logic for this increase by one number and Need to trigger an alert if it not increase by one- which indicates number missed. 00000000000000875115,00000000000000875116,00000000000000875118 In this case 00000000000000875117 is missing 00000000000000875117 00000000000000875117  ... View more

Thanks One more question , How Can I put logic to find missing number in this sequence of dynamically changing numbers: It has no logic except it increase one by one.Is there any way to build logic for this increase by one number and Need to trigger an alert if it not increase by one- which indicates number missed. 00000000000000875115,00000000000000875116,00000000000000875118 In this case 00000000000000875117 is missing 00000000000000875117 00000000000000875117  ... View more

The pattern may be:   Sequence Numbers:00000000000000872510,00000000000000872511,00000000000000872512,00000000000000872513,00000000000000872514 I need to extract only numbers without comma and display them in table like: 00000000000000872510 00000000000000872511 00000000000000872512 00000000000000872513 00000000000000872514 ... View more