Transpose Tool In Db Keeps Giving 'Transpose Not Yet Implemented'
- 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
I am trying to use the in_db transpose tool but I keep getting the error 'Transpose Not Yet Implemented' after I've completed all the configurations for it.
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For production workflows, it is not an officially supported tool (that's why it is in the Laboratory tool palette) so I'd recommend streaming the data out and using a regular Transpose tool. You are likely getting errors because the database you are connecting to doesn't support that function.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
is there another way to transpose in db without the Transpose tool if my current Big Query database doesn't support it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No - if the database doesn't support it, the database can't do it. It's worth exploring your database's language to see if there's a way, but it says on the documentation that "Transpose In-DB supports only 64-bit SQL Server and Oracle data sources": Transpose In-DB Tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alright, thank you Castor!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
my recommendation would be to use connect-in-db (or preferably dynamic input in-db) and set up the transpose (unpivot) in your sql:
using the iris-data set:
![](/skins/images/303A6AD65FCA043F1D2938424191616C/responsive_peak/images/icon_anonymous_message.png)