Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.less.tech/llms.txt

Use this file to discover all available pages before exploring further.

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.