3 Replies Latest reply: May 12, 2016 12:01 PM by Stefan Wühl RSS

    IF Condition

    Hans Müller

      Hi,

       

      please look at my example. I have this..

       

      Tabelle:

      LOAD * INLINE [

          ID, Date, IO

          1, 1.1.2015, O

          1, 2.1.2015, O

          1, 3.3.2015, I

          1, 4.3.2015, O

          1, 5.3.2015, I

          2, 10.02.2016, O

           2, 10.02.2016, I

      ];

       

      And I want to have this solution...

       

      ID, Date, Date2

          1, 1.1.2015, 3.3.2015

          1, 2.1.2015, 3.3.2015

          1, 4.3.2015, 5.3.2015

          1, 10.02.2016, 10.02.2016

       

      When Date with IO = I is smaller than Date with IO = O then this should by Date2 but only for the first I min date values...