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.