
Hi All,
The start schema that I have is pretty simple. File attached.
On one table I have address info, on the other I have spend information. I can linked both through a unique identifier.
What I'm expecting to see if:
Supplier | City | Spend
ABC Chicago 5,000
What I'm seeming is:
Supplier | City | Spend
ABC Chicago 4,000
(Blank) 1,000
For some the results are good, for other is not in the sample file. However, when I do this with all the data (2k rows for one table and 30k for the transaccitional table), I actually don't see any information in the City column.
I'm using Excel 2010 (32 bits).
Thanks for your help.
Regards,
Fernando