Is there a way to pivot columns into rows in dataset?

Persio DeLuca-Oracle

Summary:

I want to transform a group of columns with similar parameters into multiple rows.

Content (required):

I want to transform a group of columns with similar parameters into multiple rows in OAC, like the feature in PowerQuery, to enable a different visualization of data.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Wayne Van Sluys

In Oracle Analytics Desktop there is the ability to apply scripts to a data flow.

There is an example script located here

http://oracle.com/business-analytics/data-visualization/examples.html

Video of the script

https://www.youtube.com/watch?v=F32A_G97zrM

Note: Running a script in a data flow is only available in Oracle Analytics Desktop.

Joshua C. Stewart

If you're sourcing the dataset from a connection you'd be able to leverage the built in SQL Pivot function in the Manual Query selection step.

Documentation on Oracle SQL pivoting: https://blogs.oracle.com/sql/post/how-to-convert-rows-to-columns-and-back-again-with-sql-aka-pivot-and-unpivot

Benjamin Arnulf-Oracle

If you have an Oracle Database installed beside Oracle Analytics, you can use Data Flow Database analytics function to pivot and unpivot data. See youtube video here: PreviewPreview3:41OAC 5.7 - Unpivot with Database Analytics NodeYouTube · Oracle AnalyticsJul 21, 2020