When you need to parse a JSON and it contains a jagged array (array of array) it may not be immediately clear how to parse it because the “Parson JSON” action returns all values in such array as a single column. Instead, use a combination of actions “Extract JSON property” and “Split JSON array”.
Example
parse-jagged-array.zip (1.7 KB)
Source data:
{
"jagged_array": [
["A1", "A2", "A3"],
["B1", "B2", "B3"],
["C1", "C2", "C3"],
]
}
Workflow:
