Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

This content is now maintained on the CDAP wiki, here. Please add any comments to the CDAP wiki.

This page describes how to parse JSONs in Wrangler. If the JSON has arrays, this will be a short tutorial to explain how the arrays can be exploded/flattened into columns for further processing and cleanup.

Parsing JSON

Steps to follow:

  1. Go to CDF instance.

  2. Navigate to Wrangler from the sidebar (appears by clicking the hamburger icon in the navbar).

  3. From the a Wrangler source (GCS or BigQuery), read a JSON file to Wrangle.

  4. Once navigated to Wrangler tab, open the dropdown on the column and choose Parse → JSON.

  5. After Step 4, the fields in the JSON will form the column. Identify the column that has rows.

  6. Open the drop-down from that specific column and select Explode → Array (by flattening).

  7. This will explode the elements in the JSON array as individual data in the same column in Wrangler.

After step 7 further directives can be applied based on cleanup needed.

  • No labels