This content has been marked as final. Show 6 replies
I would like to detect wether or not a field has changed between two consecutives dates.
For instance, for different products (apples, bananas, lemons and oranges), 3 trucks are used for transportation.
Because of logistical issues, we could need to change trucks. Here is an example?
|Date||Product||Sales ($)||Truck||Change of truck?|
How can we detect every change of truck please?
Preferably in scripts, because the load function has a loop to load several files..
Note: the first delivery on 29/5/2017 should not be considered as a change.
Many thanks in advance,