問題
When connecting to a CSV file having columns that contain line-feed codes, the layout of the imported data is incorrect.
上次修改日期 : 09 Dec 2022
環境
- Tableau Desktop
- Excel
解決方法
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.
原因
Some of the columns contain line-feed codes.其他資訊
Text or CSV File Data Source Does Not Return All RowsText File (text file properties)
感謝您針對本文的效益提供意見回饋。
開啟新案例
繼續搜尋
知識庫
社群
產品說明
訓練及教學課程