Skip to main content
Question

filter records between certain values

C
Forum|alt.badge.img

Hi,

 

I have imported an Excel spreadsheet into FME, one of the columns contains data similar to the below, I am looking to filter the records between the PTO On and PTO Off values, anything else I wish to remove.

Is there a way to do this using FME transformers? Many thanks for any help in advance.

Ignition OnJourney StartIdle StartGPS PeriodicGPS PeriodicGPS PeriodicDigital Input 0 HighPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicDigital input 0 LowPTO OffGPS PeriodicGPS PeriodicIdle EndGPS PeriodicGPS PeriodicDigital Input 0 HighGPS PeriodicPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicIdle StartGPS PeriodicDigital input 0 LowPTO Off

 

Thanks,

Charlie

    2 replies

    sigtill
    Supporter
    Forum|alt.badge.img+24
    • sigtillSupporter
    • Supporter
    • October 15, 2019

    Using Variablesetter and VariableRetrierver should accomplish this:

    The Attributefilter_2 should filter by the name of the attribute containing PTO On and PTO Off. And the Testfilter will sort which ones to keep and not

    The real SigTill
    ebygomm
    Influencer
    Forum|alt.badge.img+39
    • ebygommInfluencer
    • Influencer
    • October 15, 2019

    You can do this with adjacent attribute handling in the attributecreator to create a flag of which records to keep. The conditional tests may need tweaking slightly depending on whether you want to include the features with values of PTO On or PTO Off or not

    Reply


    Helpful Members This Week

    Community Stats

    31,468
    Posts
    119,303
    Replies
    39,086
    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.