Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 236 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Pivot in Data Flow
Hi All,
I am working on a Data Flow in Oracle Analytics Cloud and would like to know if there is a Pivot transformation available within Data Flow.
I need to pivot rows into columns as part of my data preparation, but I am not seeing any direct option for Pivot in the Data Flow UI.
Thanks,
Jay
Answers
-
Check out this video for an example that might work for you
https://www.youtube.com/watch?v=IGk-vAlFYq8
0 -
Hi Brendan,
Thanks for the quick response. I followed the document and it is helpful for Unpivot operations. However, I need to perform a Pivot operation. Could you please let me know if there is any function or option available in OAC Data Flow to pivot data?
Thanks,
Jay0 -
Hi @Jayakumar Perumal , there is an idea logged for this feature in the idea lab, please do upvote:
1 -
Yes, it is not currently supported and vote for the idea as mentioned above.
As an alternative, consider using an external system / ETL tool that does support pivot, then bring the transformed data into OAC.0
