How-To

Extract Semi-Structured Data

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.

  1. Create a Worksheet with your semi-structured data.
  2. Open the column menu and choose ‘Extract Columns’.
  3. Use the menu to choose which data you would like to extract to columns.
  4. Check the data types on your chosen columns, and change if you need to.
  5. Click confirm!