0 Replies Latest reply: Sep 5, 2012 4:42 AM by abhi_paragon RSS

    Loading data from different tables

      Hi

       

      I am working on a project. Here I have three tables with some fields common to each table.

      I am attaching a sheet which will give u an idea on the structure of these tables.

       

      What I need to do is:

       

      Step1. Join table 1 & table 2 with Ano as the common field. Name this table as Table X

      Step2. Add a calculated field in TableX which is a concatenation of : customer, cartidge, city, state. Name the field as KEY

      Step3. Add a calculated field in Table3 which is a concatenation of CUSTOMER_NAME, Product Number,Ship City, ShipState. Name the field as KEY

      Step4. Join Table X and Table 3 with KEY as common field. The final table structure (FInal Output) is shown in attached sheet.

       

      Please help.

       

      Abhishek