IBM Watson Data & AI - Structured Ideas

This Ideas portal is being closed.  Please enter new idea at http://ibm.biz/IBMAnalyticsIdeasPortal

Allow User to refine / Split JSON Data columns into actual columns in Refinery

User can connect to Cloudant using Connected data asset and then have option to refine that

connected dataset, Now Cloudant is JSON data store and columns would come in as json data.
Now User would want to split that json data column into multiple columns.
There is no easy way to split this json data column.
For ex.
JSONCOLUMN
{"d":{"myName":"ABC.TEST1","counter":0.0}}
{"d":{"myName":"ABC.TEST1","counter":0.1}}
{"d":{"myName":"ABC.TEST1","counter":0.2}}
{"d":{"myName":"ABC.TEST1","counter":500.0}}

User would want to get columns like

myName and counter with its respective values.
The Current Data refinery UI in watson studio have no options for this.

  • charles
  • Dec 14 2018
  • Needs review
Why is it useful?
Who would benefit from this IDEA?
How should it work?
Idea Priority Medium
Priority Justification
Customer Name
Submitting Organization
Submitter Tags
  • Attach files