Skip to main content
Solved

Conditional Adjacent Feature Value Grouped by Attributes

  • October 25, 2024
  • 1 reply
  • 26 views

matthewb
Contributor
Forum|alt.badge.img+7

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.  

 

 

View original
Did this help you find an answer to your question?

1 reply

matthewb
Contributor
Forum|alt.badge.img+7
  • 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.  

 

 


Reply


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