Use the transformation builder in a JSON Parser node - Data360_DQ+ - Latest

Use the transformation builder in a JSON Parser node to parse a JSON object into output rows.

1. In an Analysis, drag a JSON Parser node onto the canvas and select the node.
2. Click Edit Transformations. The Edit Transformations window is displayed.
3. Click Add.
4. Choose an option from the drop down list:
   • Field - Select this option to start creating the JSON schema manually, or to add a field to or edit an existing schema. For details, see Building schema manually.
   • From Sample JSON - Select this option if you have an example of the JSON object that you will be parsing with the JSON Parser node. For details, see Building schema by using sample content.
5. When you have built the schema, click OK to close the Edit Transformations window.
6. In the properties panel, select the JSON field from the input node that contains the JSON you are parsing.
7. Use the Additional Output Fields panel to select and add any other input fields that you want to include in your output along with the parsed JSON. Use the Field Selector to select fields and click the arrows to move them between the Available and Selected columns.