IssueWhen running a flow in Tableau Prep Builder that contains joins or unions of MySQL and flat files, the following error message occurs:
Also, the following error can be found in the Tableau Prep Builder logs:
Install Tableau Prep Builder 2019.1.2 or a newer version. Click here for downloads of Tableau Prep: Tableau Prep Downloads and Release Notes. For more information on current releases, see Install Tableau Prep and Prep Upgrade.
Change the collation of the fields used in the join or union in MySQL to "latin1_general_ci".
Convert the flat file to a .hyper and use the .hyper in the flow instead.