14 Replies Latest reply: Mar 24, 2015 6:11 AM by Nayan Lalla RSS

    Bringing 2 tables together with similar structure

    Nayan Lalla

      Hi

       

      In our company we have branches that operate independently however they have the same structure.  I want to combine the 2 difference data source.

      Attached herewith is the mock model which are link to 2 data sources.   The one is Joburg and the other is Durban.

      The are 3 tables for each data source.

       

      1. Sales Data:           Containing Customer, Item Code and Sales Qty

      2. Customer Data:  Customer and Customer Group

      3.Item Data:              Item Code and Item Category

       

      When I reloaded the model, ITEM Category, Customer Group and “Renewable” under Division does not appear for Durban.  Please can you tell me where I am going wrong in my scripting.

       

      Kind regards

      Nayan