I am making a viz on a summary of UK earnings. The data comes from the ONS and includes various regions, districts, counties and countries in the UK and is very extensive (over a million rows)
In order to adequately map the earnings for these places, I downloaded a shapefile from the ONS (http://geoportal.statistics.gov.uk/datasets/local-authority-districts-december-2015-full-clipped-boundaries-in-great-bri… ).
However when I tried to join the data using the "Inner" option to sync the geography code columns together, my computer spends ages doing the joining and then Tableau crashes around the 200,000th row.
Anyone have an idea why this is happening?
Here is a link to my viz if it's helpful:
Thanks in advance,
If you remove the inner join is it ok? does it work fine.
You can restrict the number of rows with inner join in place and see if it works.
third option probably would be to apply few more filters either DB filter or sql filter.
as a fourth option you can use extracts instead.