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
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
Hello @Bharath
You can use the transpoe tool in laboratory https://help.alteryx.com/20231/designer/transpose-db-tool