Parsing a JSON structure stored in a field

There is the possibility that you have a JSON structure in a field of your dataset. In this case, the way to parse the structure does not differ much from what was explained previously.

If you have a field containing a JSON structure and need to parse it in order to extract some values, proceed as follows:

  1. At the end of your data stream, add a JSON input step.
  2. Double-click on the step and check the option Source is from a previous step.
  3. Under Select field:, select the name of the field that contains the JSON value.
  4. Configure the Fields tab just as you did before.

By previewing the last step, you should see the new fields extracted from the JSON structure as well as the fields coming from previous ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.