-
1. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)
Ed,
Group the countries up as per your requirements.
Then join your data to the features file.
Best Regards,
Allan
-
2. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)
Hi Allan:
Thank you very much for your response! This is great stuff! I'm pretty sure this will meet all of my needs.
Thanks, Ed
-
3. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)
Hi Allan:
Many thanks for providing your map. It's obvious that there's a lot of work in there and I am very grateful that you were so willing to share it with me. I have a couple of questions that I wonder if you can help with.
Have you or anyone else tried to use the map with a Microsoft Analysis Services data connection in Tableau? The reason I ask is that when I join to this type of connection, the dimensions/attributes and measures are grayed out.
and;
We do separate budgets for Canada and French Canada (Quebec). Is there a way for me to differentiate these?
Thanks! Ed
-
4. Re: How to handle groups of countries (e.g.: Benelux, Nordics, UK and Ireland)
Ed,
Q1 no, but I've managed a PostgresSQL/ESRI personal dB data connection before. I believe there is an extension to Microsoft SQL sever (Spatial) that would possibly help you, but I don't want to lead you down the wrong path. Would advise using Postgres SQL/PostGIS, as these are spatially aware. The tables need to be Tableau ready format though:
I.e. ID,path order,X,Y
Q2 For the split between countries and provinces, you'll need to create a hierarchy using Natural Earth Admin 0 (the file I gave you) and Natural Earth Admin 1. You can append the tables, but I'd advise using NEA0 X,Y and NEA1 X,Y so you can join tables to both and use a dimension swapper between the two. Left outer on ID of the Feature (Shapefile DBF) PostGIS comes with a handy SHP loader.