How to parse JSON with jagged array (array of arrays)

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 (1.7 KB)

Source data:

	"jagged_array": [
		["A1", "A2", "A3"],
		["B1", "B2", "B3"],
		["C1", "C2", "C3"],