Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 196 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Extract JSON fields from column of csv for filtering in OAC
Rashmi Jadhav-Oracle
Rank 4 - Community Specialist
Use Case:
I have a CSV file with multiple columns, and one of the columns is called metadata, which contains JSON values like:{'Architecture': 'x64', 'Vendor': 'One', 'DB Version': None}.
I want to extract each of these values like Architecture, Vendor, and DB Version so I can use them individually as filters or in visualizations.
Is this possible in Oracle Analytics Cloud?
0
Answers
-
You could explore using REST API connector(whose output will be parsed based on json) to create dataset in OAC and then use this dataset to define workbook and filter. Tagging PM @Avinash Krishnaram-Oracle to see if this suggestion is valid for the use case described.
0
