Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ID | AddressNK |
---|---|
1001 | AD4004 |
1001 | AD4005 |
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 | |
---|---|
1001 | AD4004 |
1001 | AD4005 |
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.
Is it possible to attach (a sample / limited rows) of your data sources?
Unfortunately not due to the nature of the data
Can you post your script part?
Hi Stuart, it's what you said in **, weird thing is this should happen when you concatenate the first address table.
ie:
Load from client --> this creates a row with Client Id unrelated to address
concatenate Load From address --> creates the 2 rows with Client related to address
Hi Ruben,
It's 2 address tables that are being concatenated thats the problem..
What I am expecting to happen is:
Load from Client = 1st entry created with nothing related
Load from Address = 1st entry from before now associated with 2 new address rows
It all works fine with the tables are not concatenated or joined. But as soon as I join or concatenate then I get this strange issue that I dont see with other data.