5 Replies Latest reply: Aug 30, 2018 3:21 AM by Alexandra Bragina RSS

    Create a new field from the Existing fields...

    xxxxx yyyyy

      I have below table.

       

      Flight                               stop type        Origin        Stop place         Destinatiom

      7031MXPFCOADD
      7371IAHDENSFO
      5071BKKKHIMCT
      15781LAXIAHBOS

       

      555/558CNXKTMSIFKTM
      557/560CNXKTMSIFKTM
      207/614CNXDARZNZDAR
      103/118CNXDARZNZDAR
      117/106CNXDARZNZDAR

      I want create a new field Flight Destination from the Existing fields. If Stop Point=1, I want Flight Destination= Destination Field records,

      or  stoptype= CNX, i want Flight destination= Stop place filed records. I want output records like...

       

      Flight Destination  (NEW COLUMN)

      ADD

      SFO

      MCT

      BOS

      SIF

      SIF

      ZNZ

      ZNZ

      ZNZ