KNOWLEDGE BASE

Unexpected results of csv including line break in cells in Tableau Prep


Published: 11 Nov 2022
Last Modified Date: 03 Jan 2023

Issue

Fields are not delimited as expected when they contain line breaks in a CSV file.
 

Environment

  • Tableau Prep Builder 

Resolution

Option 1

Change the [text qualifier] to "(double quotes)
User-added image

Option 2

Use Excel file instead of csv when there are line breaks in cells.
 

Cause

Field including a line break is not processed as expected without specifying the text quantifier.
 
Did this article resolve the issue?