1 Reply Latest reply on Apr 16, 2019 8:46 AM by Joshua Milligan

    Tableau Prep - How to trap bad characters (UTF-16LE) in a CSV file?

    Mike Stull

      How can you trap records that have bad characters in them from a very large CSV file (16+ million records)? I like to make a calculated fields that gives a count or flag marker.  I tried changing the Character Set to UTF-8 to see if that helped, but no.

      The problem is that Tableau Prep processed an Output file and when we try to loaded it we get errors during the load. Would like to know before load that file has bad records.

       

      Bad UTF-8 charactors in TableaPrep.PNG

      Thanks for the help.