6 Replies Latest reply: Jun 9, 2017 5:15 AM by Nicoals Martin RSS

    detect field changes between dates

    Nicoals Martin

      Hello all,

       

      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?

       

      DateProductSales ($)TruckChange of truck?
      29/5/2017Apples25kA-
      29/5/2017Bananas10kB-
      29/5/2017Lemons6kA-
      5/6/2017Apples21kBYes
      5/6/2017Bananas23kAYes
      5/6/2017Oranges19kC-
      12/6/2017Apples39kBNo
      12/6/2017Bananas22kCYes
      12/6/2017Oranges12kAYes

       

       

      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,

       

      Nicolas