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

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

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.