4 Replies Latest reply: Jan 19, 2018 8:10 AM by Giacinto Abbruzzese RSS

    recode field into new field

    Giacinto Abbruzzese

      Hello,

       

      how can i recode a categorical textfield into a new dummy textfield?

      i know how to do it with the INLINE command:

       

      Table:

      LOAD *,

        Pick(Match(Status, 'DELETED', 'ERROR' ,Status), 'nein', 'nein', 'ja') as Status1;

      LOAD * Inline [

      Status

      DELETED
      ERROR
      GENERATED
      MOVED
      PUBL_d3
      PUBL_PORTAL
      PUBLISH_ERROR
      NEW
      ];

       

      Is there a way to work with if-Statements in the load script?

       

       

      StatusStatus1
      DELETEDno
      ERRORno
      GENERATEDyes
      MOVEDyes
      PUBL_d3yes
      PUBL_PORTALyes
      PUBLISH_ERRORyes
      NEWyes