Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transpose Tool In Db Keeps Giving 'Transpose Not Yet Implemented'

sxa445
7 - Meteor

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. 

5 REPLIES 5
alexnajm
18 - Pollux
18 - Pollux

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.

sxa445
7 - Meteor

is there another way to transpose in db without the Transpose tool if my current Big Query database doesn't support it? 

alexnajm
18 - Pollux
18 - Pollux

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

sxa445
7 - Meteor

Alright, thank you Castor! 

apathetichell
19 - Altair

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:

SELECT * FROM `my_test_db.iris-data`
UNPIVOT(length FOR type IN (sepal_length, sepal_width, petal_length, petal_width));
 
would transpose your data with unlisted columns as key columns, sepal_length as the Value column and type as the Name column.
Labels
Top Solution Authors