Using Sigma, you can easily extract semi-structured data. When Sigma detects JSON or Variant column types, ‘Extract Columns’ becomes and option in the column menu. If your data is semi-structured and you don’t see the ‘Extract Columns’ option, you can use the type function JSON or Variant to change how Sigma interprets the column of data.
- Create a Worksheet with your semi-structured data.
- Open the column menu and choose ‘Extract Columns’.
- Use the menu to choose which data you would like to extract to columns.
- Check the data types on your chosen columns, and change if you need to.
- Click confirm!