1 Reply Latest reply: Nov 26, 2015 5:00 PM by Sunny Talwar RSS

    How to create another Column in script

      I have this table,

        

      TYPEDATE_01DATE_02
      AType AType B
      BType AType B
      AType AType B
      BType AType B
      BType AType B
      BType AType B
      AType AType B
      AType AType B

       

      and i want to create a new column DATE_03 when if ([TYPE]="A";[DATE_01];[DATE_02])

       

      This would result table

       

      TYPEDATE_01DATE_02DATE_03
      AType AType BType A
      BType AType BType B
      AType AType BType A
      BType AType BType B
      BType AType BType B
      BType AType BType B
      AType AType BType A
      AType AType BType A