3 Replies Latest reply: Sep 12, 2014 4:15 PM by Enrique Colomer RSS

    create a new column by combining values from an existing column

      Hi,

       

      I have an existing column Portfolio with values 'APPS', 'BPO', and 'ITO'. I want to create a new column GBU with values 'ABS' and 'ITO' where 'ABS' is 'APPS' and 'BPO' from the first column.

       

      PortfolioGBU
      ITOITO
      APPSABS
      BPO

       

      I have tried:

       

      Load

      ..

      ..

      Portfolio,

      if(Portfolio='ITO','ITO') and if(Portfolio='APPS','ABS') and if(Portfolio='BPO','ABS') as GBU

      ..

      From

       

      but it's not working for me

       

      Please help!