Skip to main content
Solved

Conditional Adjacent Feature Value Grouped by Attributes

  • October 25, 2024
  • 1 reply
  • 41 views
matthewb
Contributor
Forum|alt.badge.img+11

I have a dataset that has customer data, vehicle data, planned driving distance (with a bunch of other scrubbed attributes).  In this data, there are many days when a customer was not planned to have accumulated any distance but did use a machine.  If the planned driving distance to date is missing, I want to copy the value for the previous planned_Driving_dist_to_date that has a value, but I want this sorted by date and grouped by customer and machine.  

 

The attached spreadsheet shows my dataset. 

Best answer by matthewb

@takashi post HERE solved my issue.  Using Global Variables named with the machine name as part of the variable, such as “vconfirmed_@Value(machine)”, was the needed piece.  

 

 

1 Attachments
    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    matthewb
    Contributor
    Forum|alt.badge.img+11
    • matthewbContributor
    • Author
    • Contributor
    • Best Answer
    • October 26, 2024

    @takashi post HERE solved my issue.  Using Global Variables named with the machine name as part of the variable, such as “vconfirmed_@Value(machine)”, was the needed piece.  

     

     

    Community Stats

    32,154
    Posts
    122,043
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.