5 Replies Latest reply: Feb 12, 2015 4:28 PM by Stuart Frew RSS

    Concatenate doing strange things

    Stuart Frew

      Struggling with this one....


      My first stage is 2 concatenate 2 'CLIENT' tables


      Then I load in 1 Address table


      Everything at this stage is fine:-


      Client IDAddressNK


      Then I concatenate another ADDRESS table from another source.


      The link between the Client Table and Address Table appears ok in the Table viewer but when I in new Table charts to the tabs there are nulls showing..the link has dropped off.



      **I think what I am seeing here is the first 2 rows are actually data from the ADDRESS table, the 3rd row is data from the Client table which cannot seem to find the data in the Address table


      Help please - totally stumped with this one.