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:

Link	Notes
Row	A frequently used extraction method.
Fixed Table	A frequently used extraction method.
Types	Filter and type your output.

Initial config

To undo all your changes, paste the following config into the left pane of the JSON 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"
        }
      }
    }
  ]
}

Updated 23 days ago