0 Replies Latest reply: Mar 8, 2017 10:35 AM by juan prado RSS

    Create a new field

    juan prado

      Hey guys i need your help for create a new field in my table.

       

      I have this table and the action to do in the column TO DO


           

      %ID%secDATE_FROMDATE_TOTYPEFilterTO DO
      263414603427/02/2015Aonly one A
      263414603327/02/2015A-take min (DATE_FROM) for same %ID and same %sec
      263414603329/02/2016 Amultiple Adelete row
      263414602629/12/2014A
      263414603001/03/2015A
      263414602329/12/2014A take date_to from TYPE C and delete row with type C
      263414602329/02/2016 C delete row

           


      I need to create a new table like this

       

        

      %ID%secDATE_FROMDATE_TO
      263414603427/02/2015today ()
      263414603327/02/2015today ()
      263414602629/12/2014today()
      263414603001/03/2015today()
      263414602329/12/201429/02/2016

       

      Thanks!