Read a tableau twb with Alteryx?
- 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
a tableau .twb file is essentially an XML file. Alteryx supports XML file reading. Can I read/manipulate .twb? I am referring to the dashboard folder itself, not the extract file.
Reason being is I need to mass edit some .twb files, and thought it could maybe get done with Alteryx.
Solved! Go to Solution.
- Labels:
- Tableau
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If the changes that you want to make can be accomplished with a "Find" & "Replace" command, then they surely can be made with alteryx. I'd read the input file in with a .csv driver and set the delimiter to \0 (null). Now you can read and edit the file. When you save the file, go to a .txt file and make your file format .csv. You can use the same \0 delimiter and UNCHECK the First Row Contains Field Names.
cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Mark,
thank you for the tip, I was selecting XML and it was not working. Yes, I am trying to make simple find and replace.
Could you elaborate more on the saving? like output it as a text?
Thank you,
Jasson
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've also documented previously the steps required to import a twb file into already...
https://benjnmoss.wordpress.com/2016/10/24/how-to-import-a-twb-in-alteryx/
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@benmoss
Hi Ben,
Please note I have a workflow which reads through Tableau WBK metadata from TWB files. I am facing an issue while trying to get Table name for a column. Let me know if you have come across similar issue. Let me know if you want me to share the workflow.
Thanks,
Vishant
