I have a file that has 9 digit zip codes that Tableau does not recognize. Is there a calc to change 9 digit zip to 5 digit zip?
Burt, first thing to try is manually assigning it a geography (Rt-click Geography Role\ Zip Code/Postal Code) If that doesn't work put this in a calculated field:
LEFT(STR([ZIP/Postal Code]),5 )
Then you'll need to manually assign the geography to this field. Hope this helps.