Cheatsheet part 2

Tables and rows

Solution: Mix it up

After you've completed all the Mix it up steps in the tutorial, the final config is:

{
  "fields": [
    {
      "id": "second_most_popular_snack",
      "anchor": "second",
      "type": "string",
      "method": {
        "id": "row",
        "position": "right",
        "tiebreaker": "last"
      }
    },
    {
      "id": "snack_table",
      "anchor": "tables and rows",
      "type": "table",
      "method": {
        "id": "fixedTable",
        "columnCount": 6,
        "columns": [
          {
            "id": "third_column",
            "index": 2
          },
          {
            "id": "sixth_column",
            "index": 5,
            "type": "phoneNumber"
          }
        ],
        "stop": {
          "type": "startsWith",
          "text": "mix it up"
        }
      }
    }
  ]
}

Solution: Challenges

After you've completed all the Challenges steps in the tutorial, the final config is:

{
  "fields": [
    {
      "id": "second_most_popular_snack",
      "anchor": "second",
      "type": "currency",
      "method": {
        "id": "row",
        "position": "right",
        "tiebreaker": ">"
      }
    },
    {
      "id": "snack_table",
      "anchor": "mix it up",
      "type": "table",
      "method": {
        "id": "fixedTable",
        "columnCount": 3,
        "columns": [
          {
            "id": "second_column",
            "index": 1
          },
          {
            "id": "third_column",
            "index": 2,
            "type": "string"
          }
        ],
        "stop": {
          "type": "startsWith",
          "text": "challenges"
        }
      }
    }
  ]
}

Learn more

To learn more about the steps you took in the tutorial, see:

LinkNotes
RowA frequently used extraction method.
Fixed TableA frequently used extraction method.
TypesFilter and type your output.

Initial config

To undo all your changes, paste the following config into the left pane of the SenseML editor:

{
  "fields": [
    {
      "id": "second_most_popular_snack",
      "anchor": "second",
      "type": "string",
      "method": {
        "id": "row",
        "position": "left",
        "tiebreaker": "first"
      }
    },
    {
      "id": "snack_table",
      "anchor": "tables and rows",
      "type": "table",
      "method": {
        "id": "fixedTable",
        "columnCount": 6,
        "columns": [
          {
            "id": "ranking",
            "index": 1
          },
          {
            "id": "liked_by",
            "index": 5,
            "type": "percentage",
            "isRequired": true
          }
        ],
        "stop": {
          "type": "startsWith",
          "text": "in part 2"
        }
      }
    }
  ]
}