This page describes how to parse JSONs in wranglerWrangler. 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,:
Go to CDF instance.
Navigate to wrangler Wrangler from the sidebar (appears on clicking the hamburger icon in the navbar).
From the a wrangler Wrangler source (GCS or BigQuery) read a JSON file to wrangleWrangle.
Once navigated to wrangler Wrangler tab, open the dropdown on the column and choose Parse → JSON.
After Step 4, the fields in the JSON will form the column. Identify the column that has rows.
Open the dropdown drop-down from that specific column and select Explode → Array (by flattening).
This will explode the elements in the JSON array as individual data in the same column in wranglerWrangler.
After step 7 further directives can be applied based on cleanup needed.
Related articles
| Page Properties | ||
|---|---|---|
| ||
|