This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 12-01-201608:02 AM- edited
a week ago
Every so often we get questions about a .tde (Tableau Data Extract) file that is being output from Alteryx that has a file size of 30k when the original data is much larger. When the file is opened in Tableau this error sometimes comes up:
An error occurred while communicating with data Source ‘yourfilename.tde’
Sometimes it may not be easy to identify fields with those characters. “So how do I find them?” you ask.
Here are a couple things to try:
If your table isn’t too large scan through it to see if anything pops out.
Try saving each field out as a file all to itself. If a file is 30k in size it is worth investigating that field of data. To try this method use a Select Tool to select one field at a time and then save it to a .tde file. The results may look like this:
So the possible trouble column has been identified, now what? Examine the field to see if there are any characters that may be ‘out of the ordinary’. Then in either an existing Select Tool or by adding a new one, find the field in question and change its data type to V_WString and try saving it to a .tde again. If the file size is different that 30k it may have corrected the issue.
So what if there are too many fields in the data to save them out one by one manually? Batch macro to the rescue! Create a batch macro to loop through each field and save it out to an individual file for examination.
A workflow is attached (created in Alteryx 10.6) that shows an example of a file that saves incorrectly to a .tde, that is fixed and saves correctly to a .tde and includes an example of a macro that saves each column as its own file.