# Update

<figure><img src="/files/EboLkTVWKf9C4AaDpUQq" alt=""><figcaption></figcaption></figure>

The **Update** task in **Gaio DataOS** allows you to modify existing records in a table based on custom filter conditions. This is ideal for correcting data, applying transformation rules, or dynamically synchronizing values during ETL flows.

{% hint style="warning" %}
&#x20;**Important:** This task can only be used when a table is selected in the flow. Be sure to add and connect a Table before configuring the update.
{% endhint %}

***

## &#x20;How to Use

### **1. Insert and Select a Table Block**

* Add a **Table** to your flow and choose the dataset you want to work with.
* The Update task will only become available once a table is selected.

***

### **2. Open the Update Task**

* In the left-hand menu, go to:\
  **Tasks > ETL > Update**

***

### **3. Configure Basic Info**

* **Task label**: (optional) Add a name for the task to identify it in your flow.
* **Table**: The table should be automatically linked from your selected block (e.g., `new_sales`).

***

### **4. Select Columns to Update**

* In the **Columns** section, choose the fields you want to update.
* For each selected column, define:

**Type:** Defines how the new value will be set:

* `Value`: Static input
* `Parameter`: Uses a predefined variable
* `Computed`: Accepts formulas (e.g., `now()`, `1 + 1`) |

**Value:** Enter the new value or expression

***

### **5. Set Filter Conditions**

* In the **Filters** section, specify which records should be updated.
* For each filter:

| Field        | Description                                         |
| ------------ | --------------------------------------------------- |
| **Column**   | Select the column to filter by                      |
| **Type**     | Input type (e.g., `Value`, `Parameter`)             |
| **Operator** | Comparison logic (e.g., `Equal to`, `Greater than`) |
| **Value**    | The value to match                                  |

Example:\
Update the `order_date` only where `order_id = 1001`.

{% hint style="warning" %}
**Important:** If there are no filters, all rows in the table will be updated.
{% endhint %}

***

### **6. Execute or Save**

* **Run**: Immediately executes the update (one-time).
* **Save**: Saves the configuration to your data flow.
* **Save and Run**: Saves and executes the update at once.

***

#### Use Cases

* Correct outdated or incorrect values
* Apply standardization rules (e.g., replace empty values)
* Use dynamic inputs via parameters
* Update timestamps or statuses during automated flows


---

# 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.gaiodataos.com/tools/tasks/etl/update.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.