Skip to main content
Question

Q: Find missing number from sequence of column data

Z
Forum|alt.badge.img

Hi there, so I have two column of data.

​

The column "Test_FloorNumber_Begin0" should have sequence of 0000, 0001, 0002, 0003 - the largest number of the input, or 0999.

​

The second column "Test_FloorNumber_Begin1" should have sequence of 1000, 1001 - the largest number of the input, or 1999.

​

The sequence should start from 0000/1000 to the largest number from the input data.

 

So I want to use FME to find out the missing number and output it. In this case 0000 to 0003 and 1002-1003 are missing.

​

Please help me as I want clueless on how to work this out.

​

Thank you very much.

1 Attachments

    2 replies

    danilo_fme
    Evangelist
    Forum|alt.badge.img+45
    • danilo_fmeEvangelist
    • Evangelist
    • October 5, 2021

    Hi @zacharylee1204​ 

     

    The PythonCaller transformer is good in this case.

     

    In the Workspace template ( FMWT ) there are 2 transformers PythonCaller - each attribute:

     

    gapsResult in Data Inspector:

    Result 

    Thanks in Advance,

    Danilo

    Z
    Forum|alt.badge.img
    danilo_fme wrote:

    Hi @zacharylee1204​ 

     

    The PythonCaller transformer is good in this case.

     

    In the Workspace template ( FMWT ) there are 2 transformers PythonCaller - each attribute:

     

    gapsResult in Data Inspector:

    Result 

    Thanks in Advance,

    Danilo

    I will try it later today. Thank you very much! :)

    Reply


    Helpful Members This Week

    Community Stats

    31,491
    Posts
    119,380
    Replies
    39,113
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.