5 Replies Latest reply on Mar 28, 2018 5:57 PM by William Ayd

    Strange behavior with CSV files

    Tim Jackson

      The problem is similar to the one below:

      Extra Columns not in my CSV??

       

      I save a CSV file (after some manipulation using pandas in python), when tableau looks at it I get FXX extra columns and tableau seems to also have some problems interpreting the columns order as values from one column shift into others.

       

      The previous answer, which may well apply to my file, is spurious commas or extra quotations. What's curious is if I add some "padding" columns at the end, containing just the integer value 1 this fixed the problem.

       

      Does anyone know why this might fix the problem? perhaps it gives a clue as to how I might fix this without the padding columns?