Skip to main content

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. 

@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