KNOWLEDGE BASE

Applying Field Separator and Locale to Multiple CSV Files Joined with the UNION Feature


Published: 31 Oct 2016
Last Modified Date: 01 Nov 2016

Question

How to apply a field separator and locale to Multiple CSV files joined with the UNION feature.

Environment

  • Tableau Desktop
  • Flat Files

Answer

  1. Connect to the folder where the Flat files (CSV, XLS, etc..) are located.
  2. Do the Union on all the needed files.
  3. Change the Locale setting from the Machine locale to the File format locale.
    • For example, if the opening CSV file contains a comma as a Field separator, move the Locale value to English (United Kingdom) or similar.
  4. All files will show the correct column results.
Did this article resolve the issue?