Issues Outputting As A Tableau Extract
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Everytime I run a workflow and want to output the data as a Tableau Extract it says it's finished running and exports a 30kb Tableau Extract that cannot be opened (it's much smaller than it should be). Does anyone know why this is and whether there's a workaround?
I've tried outputting my workflow as an Alteryx DB and then outputting straight from that to a Tableau and I get the same result.
Any help would be much appreciated.
Andy
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm sure I've exported the same words before, with the same foreign characters, just in amongst my data, rather than at the bottom of my data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I used Alteryx to read in SQL DB data containing these non-English characters and create a TDE & XLS :
- months ago on v8* (which was fine) and
- in December on 9.1.0.49438 (which was not correct). The Dec outputs were created and opened fine but the fields with foreign characters have odd-looking characters instead of the character that should have been there (eg Ö).
I got the problem when I input from SQL Server DB but not when I input from an xls version of the data, so this might be a work around for you.
The Alteryx version 9.1.1.51276 still had issues going directly to a tde when using certain Unicode characters (the non-english letters). I have not tested the more recent versions. If you are on the most recent version and still have the problem then you may wish to raise it with client services and the product team
Hope that helps
Susan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Mike Akey from Client Services actually found a fix for this & let me know on 7 March:
Thanks so much Mike!!!
Susan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have similar issue of Tableau output. I'm on version 11.0.3.25674.
The Tableau output not only have a 30kb file but also a larger .bak file. None of them can be open normally in Tableau.
I have changed all strings to V_WString and the issue is sill there.
Any idea?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
using the latest version 11.5.1.31573 and a .csv file in input, I fixed my problem (output data in tde format - 30Kb), just modifying the Code Page setting in the Input Data options as follow :
Old value: default ISO 8859-1 Latin
New value: Unicode UTF-8
Hope this helps
Regards
Alessandro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is a hit and trial solution. Product team should take it seriously and publish a permanent fix. Alteryx logs say all the records have been written successfully, whereas we get a 30kb TDE.....its verrrryyyy frusssssttttaatttinggggg!!!!
