KNOWLEDGE BASE

Copy Pasted Data With Line Breaks Appears with Extra Records in Tableau


Published: 16 Nov 2018
Last Modified Date: 18 Jan 2019

Issue

When copying and pasting data that contains line feeds (line breaks, EOL, newline), the data may appear with more records than expected in Tableau Desktop. 

Environment

  • Tableau Desktop
  • File based data source (Excel, Text, CSV)

Resolution

Remove any line feeds from the data before copying it into clipboard or Tableau. 

 

Cause

Tableau reads the line feeds as new rows of data.
 
Did this article resolve the issue?