Skip to main content
The Flatten JSON tool should be used as a last resort when working with JSON data stored in Text columns. It is much easier to use the Columns tool to convert JSON data into a an Object or List and then Parse or Explode the data into separate columns. However, that is only possible if the JSON data schema is uniform. Sometimes, a JSON object has a nested structure where one row might contain a number and another row might contain an object. In that case, the Flatten JSON tool can be used to flatten the JSON object into a table. With the Flatten JSON tool, all the JSON is parsed into a table with one row per JSON object. That means that the resulting table will be a rather long table with many rows. Typically, you should use the Split Columns tool afterwards to separate the columns headers (and nested objects) into separate columns.