Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

transposing table in SQL server Using Alteryx

Highlighted
Asteroid

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels