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
Customer Name
Role Summary Data Engineer
  • Attach files