# Insert a Row

### Overview

This procedure inserts a row into the table with given data at the specified row number.

### Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

<details>

<summary><code>insert a row in the table where</code></summary>

#### What does it do?

Initializes row insertion.

#### Where does it go?

This phrase should be written on a **new line**.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — A reference to **the table** must be defined.

</details>

<details>

<summary><code>the row number is x</code></summary>

#### What does it do?

Specifies the row number to insert the new row at.

#### Where does it go?

Indented under `insert a row in the table where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **x** with a row number. *Note: Table rows are numbered starting with 1.* If not provided, the row will be inserted at the end of the table.

#### Example

```
the row number is 3
```

</details>

<details>

<summary><code>the {name} is {value}</code></summary>

#### What does it do?

Specifies the row data to be inserted.

#### Where does it go?

Indented under `insert a row in the table where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **name** with the name of the column and replace **value** with the value to insert.

#### Example

```
the row number is 3
```

</details>

### Examples

#### 1. Insert a Row Without Specifying Row Number

To insert a new row into the table without providing a row number or a reference to a row, we specify data for all the columns in the table.

```
insert a row in the table where 
    the Name is "Beet"
    the Color is "Red"
    the Type is "Root"
```

#### 2. Insert a Row When Specifying a Row Number

For this example, `the row` refers to the following row:

| Name | Color | Type |
| ---- | ----- | ---- |
| Beet | Red   | Root |

```
insert the row in the table where
    the row number is 2
```