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
      1001AD4004
      1001AD4005

       

      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.

       

      AddressNK
      1001AD4004
      1001AD4005
      1001-

      **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.