There's no way to do this without comparing what the unknowns are against a full list of the data. One possible option to make the process easier would be to create a second workbook and build out a crosstab so that you can easily see which zip codes don't match up with the rest of the data. This also would be a good one to add to the Ideas section!
Is there a solution to this issue yet? I have a list of cities/states that aren't matching on my map because there are errors in our data (spelling errors, mismatched cities and states) and I would love to be able to export this error list and send it to our Records group to fix.
2 of 2 people found this helpful
Zareen, good news. There actually is a way to get at your bad data. Here are the steps:
- Click the "xxx unknown" indicator in the lower right corner of your map
- Click the "Show Data at Default Position" option
- Find the new marks just off the coast of Africa (this is Null Island)
- Do a box (lasso) select around these marks. (Careful NOT to click-select, you'll only get the top mark.)
- Hover over your selection so you get a tooltip and then click the data symbol
Now you'll have a text table you can copy and send off to the bad-data folks! Hope it helps.
EDIT: One thing to keep in mind, Tableau is 'Cities' aware for towns larger than 16,000 (I think, but it could be 20,000 I never remember). So those could just be a Tableau limit and not the bad-data folks fault.
That's perfect! Thank you so much!
You're very welcome!
There's another way too:
Create your map.
Drag Longitude (generated) to the filter shelf.
In the filter, change to the Special tab and choose "Null values"
Remove Latitude (generated) from your viz
Move the geographic fields from the Detail shelf to the Row shelf.
Then you have a viz of the records that don't match.