Connect Tableau to a Pipe Delimiter Text File

This article shows how to connect with the Pipe or Vertical Bar delimiter text file, load its data into the Tableau desktop, and design a chart. The third screenshot on this page below shows that each column is separated by a Pipe or Vertical Bar.

Connect Tableau to a Pipe or Vertical Bar Delimiter Text File

Clicking the text file option will open the window to choose the Pipe delimited file.

Choose the Text File

As you can see, the Tableau desktop loaded the Pipe file and automatically separated the columns using a Vertical Bar delimiter. For more Data Sources >> Click Here.

Connect Tableau to a Pipe Delimiter Text File

If this is not the case, click the down arrow beside the Employee Pipe Delimiter text file and choose the Text File Properties.. option. By default, the desktop has chosen a Vertical Bar as the Field separator. 

If not, by any chance, it has chosen a comma; the data looks like below. Please change the Field Separator from Comma to Vertical Bar from the list of available separators.

Change Field Separator to Pipe Delimiter

Drag Income to Rows and Education to Columns shelf. Next, add the Education dimension to the Color shelf and Income to the Label. For more Charts >> Click Here.

Connect Tableau to a Pipe or Vertical Bar Delimiter Text File ad create a bar chart