2 Replies Latest reply: May 11, 2011 4:24 AM by Muncho Ts RSS

    Match fields and add to table

    Gerhard Laubscher

      Hi,

       

      If I am loading from two separate tables and they have one matching field, how do I add a new field to the second table using data from the first?

       

      So:

       

      Table 1 - Field A and B

      Table 2 - Field A

       

      I need to add Field B to Table 2.

       

      Example:

       

      Table 1:  

      Field AField B
      12345xyz
      4444aaa
      5555bbb
      6666ccc

       

      Table 2:

      Field AADD NEW FIELD HERE
      12345xyz
      7777
      8888
      9999


      Thanks,

       

      G