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

Version 1 Next »

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/cleanup

Parsing JSON

Steps to follow,

  1. Go to CDF instance

  2. Navigate to wrangler from the sidebar (appears on 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 dropdown 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