Export to Tableau Fails Periodically
When exporting workbook data to Tableau, my job periodically fails. When I inspect the Tableau workbook, I can see some unexpected additional columns in my data set.
Check your data in your Datameer workbook for structure similar to the following:
Tableau attempts to break this detail out into new columns. The error occurs when the number of "key:value" pairs change between exports.
In order to preserve a delimiter but remove Tableau's procedure to expand the record, it is recommended to use a REPLACEALL() function to swap the commas "," for pipes "|".
This normalizes exported data and ensure successful executions.