Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 306 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI 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
