3 Replies Latest reply: May 8, 2017 7:47 AM by Sunny Talwar RSS

    Merge one field into another

    Tom Neal

      Hi all,

       

      I am trying to move values from one field into another.  Currently I have my dataset looking like below:

       

      This table is created by left joining on number with the pulling field being location2.

      I want to move the values from location2 into the location field.  

         

      NumberPalletLocationLocation2
      11aaaLondon
      11aabLondon
      11aabLondon
      2 Paris
      22fbb Paris
      22fbb Paris
      22fbb Paris
      33SabMadrid
      33SadMadrid

       

       

      Thanks,

      Tom