Loading

Unexpected Values from Dataset Containing Special Characters in Tableau Desktop

Data pubblicazione: Apr 13, 2024
Operazione
When connecting to a dataset containing special characters, Tableau Desktop does not show the expected values.
Fasi
Verify that the encoding type (also called character set) is appropriate for the dataset being used. You might need to switch to UTF-8, AINSI, LATIN1, LATIN2, etc. If in doubt on how to proceed, please contact your database administrator. 
  1. If using the Text file connector, this can be set on Tableau Desktop itself it. Just adjust the 'Character set' value in Text file properties. For more information, see Text Files in Tableau Help.
  2. As an alternative solution, use a TDC file to set the 'Character set' value as needed. For example, in a TDC file : 'Character set' = 'source-charset' - here is a TDC script example used for Statistical files:
<connection-customization class='stat-direct' enabled='true' version='9.1'>
     <vendor name='stat-direct' />
     <driver name='stat-direct' />
     <customizations>
        <customization name='source-charset' value='UTF-8' />
     </customizations>
</connection-customization>
Risorse aggiuntive
For more information about how to apply TDC files to Tableau Desktop and Tableau Server, see Customize and Tune ODBC Connections in Tableau Help.
Numero articolo Knowledge

001453723

 
Caricamento
Salesforce Help | Article