0 Replies Latest reply: Jul 12, 2017 4:15 PM by Robert Waterval RSS

    Dataset manipulation

    Robert Waterval

      Hi Guys,

       

      I need to manipulate the following dataset with a set analysis in the front end or sort of calculation in the back end.

      I have flags in fields for calculating movements.  But now need to change the flags of the last counter date (=always the last Day of the Month,)

      As you can see is that this movement of the last day of the Month should be manipulated to Counter Date+1 and that the current record actualty didn't happend...I should be placed

       

      Orginal dataset:

       

      Counter Date      %OrderLineID      _Cont_Move_NEG           _Qty_Saldo_WEEK

      04/06/2017           101368                            -                                              1

      11/06/2017           101368                            -                                               1

      18/06/2017           101368                           -                                                1

      25/06/2017           101368                           -                                                1

      30/06/2017           101368                           -1                                              0

       

      New / Output Dataset:

       

      Counter Date      %OrderLineID      _Cont_Move_NEG           _Qty_Saldo_WEEK

      04/06/2017           101368                            -                                              1

      11/06/2017           101368                            -                                               1

      18/06/2017           101368                           -                                                1

      25/06/2017           101368                           -                                                1

      30/06/2017           101368                           -                                                1

      01/07/2017           101368                           -1                                              0


      --


      I was thinking about inter record function (backend or a rangsum frontend)

      Every advice is welcome!

       

      Kind regards

      Robbie