4 Replies Latest reply: Aug 23, 2011 1:04 PM by Daniel Rozental RSS

    Applymap instead of left join

      I have two tables;

       

      Table 1:  Client_ID, Specialty, State, ...    (1.5 million rows)

      Table 2: Client_ID, Corp_Specialty, Corp_State,......   (2 million rows)

       

      I want to replace Specialty and State from Table 1 with Corp_Specialty and Corp_State of table 2 for every matching Client_ID. I can do this using left join, but I want to use mapping load and Applymap. Can anyone help me with the syntax? Thanks!