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.