Problème
When connecting to a CSV file having columns that contain line-feed codes, the layout of the imported data is incorrect.
Date de dernière modification : 09 Dec 2022
Environnement
- Tableau Desktop
- Excel
Résolution
To handle data containing line-feed codes in CSV format, follow the steps below.1. When preparing CSV files, columns containing line-feed codes should be enclosed in a text qualifier such as double quotation marks (").
2. Open Tableau Desktop and select the Text file connector and connect to the CSV file.
3. On the canvas, click the table drop-down arrow and select Text File Properties.
4. Change Text qualifier as you need.
Cause
Some of the columns contain line-feed codes.Informations supplémentaires
Text or CSV File Data Source Does Not Return All RowsText File (text file properties)
Merci de nous avoir donné votre avis sur l’efficacité de l’article.
Ouvrir un nouveau cas
Continuer la recherche
Base de connaissances
Communauté
Aide produit
Formation et tutoriels