# Update a Column in a Table

### Overview

This procedure updates a column in a table.

### Input Concepts

| Concept              | Type  | Description                                      | Default    | Required                                                                                                                                                               |
| -------------------- | ----- | ------------------------------------------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `table`              | Table | The table that contains the column to be updated | No default | Yes                                                                                                                                                                    |
| `the column name`    | Text  | The name of the column to be updated.            | No default | Yes                                                                                                                                                                    |
| `the column values`  | List  | The values to update the column with             | No default | Either `the column values` or `the column formula` must be provided for this procedure. If `the row numbers` are specified, then `the column values` is also required. |
| `the column formula` | Text  | A formula applied to the column                  | No default | Either `the column values` or `the column formula` must be provided for this procedure.                                                                                |
| `the row numbers`    | List  | The row numbers that apply to the column update  | No default | No                                                                                                                                                                     |
| `the other table`    | Table | Another table to reference                       | No default | No                                                                                                                                                                     |

### Output Concepts

| Concept | Description                        |
| ------- | ---------------------------------- |
| `table` | The table with the column updated. |

### Examples

In the examples below, `the table` refers to the following table, which can be generated using the `create a sample table` procedure:

| Name | Number             | Address          | City          |
| ---- | ------------------ | ---------------- | ------------- |
| john | + 1 (415) 691 9426 | 123 east street  | San Francisco |
| joe  | + 1 (415) 691 1234 | 321 west street  | San Jose      |
| jack | + 1 (415) 691 4595 | 213 north street | San Francisco |

#### 1. Updating a Column by Specifying the Column Values

{% tabs %}
{% tab title="Automation" %}

```
update the column in the table where
    the column name is "City"
    the column values are "Mountain View", "Cupertino", "Fremont"
```

{% endtab %}

{% tab title="Results" %}

| Name          | Number             | Address          | City          |
| ------------- | ------------------ | ---------------- | ------------- |
| john          | + 1 (415) 691 9426 | 123 east street  | Mountain View |
| joe           | + 1 (415) 691 1234 | 321 west street  | Cupertino     |
| jack          | + 1 (415) 691 4595 | 213 north street | Fremont       |
| {% endtab %}  |                    |                  |               |
| {% endtabs %} |                    |                  |               |

#### 2. Updating a Column by Specifying the Column Values and Row Numbers

{% tabs %}
{% tab title="Automation" %}

```
update the column in the table where
  the column name is "City"
  the row numbers are 1,2
  the column values are "Dallas"
```

{% endtab %}

{% tab title="Results" %}

| Name          | Number             | Address          | City    |
| ------------- | ------------------ | ---------------- | ------- |
| john          | + 1 (415) 691 9426 | 123 east street  | Dallas  |
| joe           | + 1 (415) 691 1234 | 321 west street  | Dallas  |
| jack          | + 1 (415) 691 4595 | 213 north street | Fremont |
| {% endtab %}  |                    |                  |         |
| {% endtabs %} |                    |                  |         |

In this example, multiple rows (1 & 2) are updated with the same value (Dallas).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/update-a-column-in-a-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.