I am not finding any known issue for the unexpected behavior. One troubleshooting step would be to download the latest version of Tableau Desktop 10.1 and attempt the connection.
Also, once the connection has been established, if the only issue is that some values are being recognized as measures that should be dimensions we can convert them in the workbook.
+ Right click the field in question > Convert To Measure or Convert to Dimension.
Additional information can be found here: Convert a Measure to a Dimension
Hope this helps!
1 of 1 people found this helpful
Right now, Tableau isn't able to display value/variable labels from SPSS .sav files. There are a couple workarounds you can try, though they may not be ideal for your situation:
- Rename the fields in Tableau Desktop, or
- Change the column names in SAS.
- use a calculated field with a CASE statement to create string values that can be used as Value Labels. For example:
CASE [Gender Field] WHEN 1 THEN 'MALE' WHEN 2 THEN 'FEMALE' END
Additionally, you can submit an idea in our Ideas forum and vote it up as a request to have this functionality added. I searched there a little, but didn't find a similar one.
If your dataset is not too big, what you can do is save the SPSS as an Excel file and checking the "Save value labels where defined instead of data values" checkbox. Then use the excel as the data source instead of the SPSS file.
You could also save as CSV, in which case the Excel row limit would not apply