1 of 1 people found this helpful
Hey Steve -
We don't support (correctly, anyway) displaying two completely unrelated datasets on a sheet. You'd want to use blending.
You may also run into an issue because we don't automatically geocode fields in the secondary dataset during a blend.
Your thoughts about JOINing these two suckers together and bringing the data in as a single data set is probably the smartest way to go.
Let us know what happens!
Off to SQL Server I go!
Create a column customers in customer table and a column suppliers in suppliers table and union. Then in your unioned table you'll easily be able to split them back out again...
Ok, but what about filled maps? I have sales in one database and zip in another, liked by account number.
I can total sales by zip but I cannot make a filled map?
Since this question is marked as "answered", I would suggest opening a new thread/discussions to ask your question, as you will probably get more/better responses as a result.
I wouldn't use filled maps to achieve this: for Zip, assuming USA, use USGS ZCTA (Tiger) SHP file, and join the sales data.