Export to Tableau Fails Periodically

Problem

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.  

Cause

Check your data in your Datameer workbook for structure similar to the following:

{"key":["value"],"key1":["value"],"key2":["value"],"key3":["value"]}

Tableau attempts to break this detail out into new columns. The error occurs when the number of "key:value" pairs change between exports.    

Solution

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.