4 Replies Latest reply: Oct 12, 2017 9:37 AM by Pakalapati Sai Kumar RSS

    Generate New Column based on other column

    Pakalapati Sai Kumar

      Hello All,

       

      I'm pulling some data from a DB as in the below format, and would like to generate a new filed based on the data i have.

       

      Sample Table:

      Product     ArtikelNr.
      A1
      A2
      A5
      A10
      B15
      B20
      B30
      D50
      G80
      F20
      C30
      E50

       

       

      Expected Result:

      Product     ArtikelNr.   Percentage
      A170
      A270
      A570
      A1070
      B1570
      B2070
      B3070
      D5070
      G8085
      F2085
      C3070
      E5085

       

       

       

      So, basically if the Product is A, B, C, D i would like to populate the Percentage column as 70 and for all the other Products i would want 85.

       

      Please, suggest the best possible way. Already tried doing Inline Load but, doesn't seem to work some how.

       

       

      Thanks!!