6 Replies Latest reply: Feb 20, 2017 11:24 AM by Sunny Talwar RSS

    Fill specific value in field

    Rakesh Pareek

      Hi,

       

      Below is my sample data:

      ABC
      111100
      112101
      113222
      211321
      213123
      313456
      311231

      It have 3 columns. I want 4th (output column) which have the values of combination of A and B(where B=11).

      My output will be like this:

       

      ABCD
      111100100
      112101100
      113222100
      211321321
      213123321
      313456231
      311231

      231