transposing table in SQL server Using Alteryx

Question

Hi,

i using "In-Database" tools in Alteryx for doing my Data blending but I can't find the Transpose option in Alteryx under "In-Database" Module. so we don'r have Transpose under "In-Database" ?

how we can perform the transpose in Alteryx if we use IN-Database tools ?

Thanks,

VJ

simonaubert_bd · Answer

Hello @Bharath

You can use the transpoe tool in laboratory https://help.alteryx.com/20231/designer/transpose-db-tool

MarqueeCrew · Answer

I found a couple of articles about how to use PIVOT functions in Oracle or SQL Server:

SQL Server:

http://stackoverflow.com/questions/20111418/sql-server-transpose-rows-to-columns

Oracle:

http://oraclecoder.com/tutorials/how-to-transpose-columns-to-rows-in-oracle--2435

Hopefully this helps you.

Cheers,

Mark