I'm trying to create an inner joing between a shapefile (1960 census) with a SPSS save file. The problem I'm having is that the linking variable - a census tract number - imports from the shape file as an integer but the SPSS variable becomes a double-precision floating-point number (even though it isn't when opened in SPSS).
This was done in Tableau Public <https://public.tableau.com/views/1960censustracts/Sheet1?:embed=y&:display_count=yes >
Thank you,
Jamie
2 answers
Try Tableau 10.2's "Join Calculations": Tableau 10.2
You should be able to create a calc like INT([census tract number]) and align data types.