# Table to Parameters

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

The **Table to Param** task in **Gaio DataOS** allows you to convert values from one or more table columns into reusable **parameters** within your flow.\
This feature is ideal for dynamically extracting data and using it as input in other tasks, filters, or dashboards.

{% hint style="warning" %}
This task can only be used when a **table is selected** in the flow.️&#x20;
{% endhint %}

***

## &#x20;How to Use

### **1. Open the Task**

In the left-side menu, go to:\
**Tasks > ETL > Table to Param**

***

### **2. Set Basic Information**

* **Task label**: (optional) Name for identifying this step in your flow.
* **Table**: Automatically populated with the selected table (e.g., `new_sales`).

***

### **3. Advanced Options**

&#x20;**Save values as default**

When enabled, this will store the extracted parameter values as default values, available outside the current flow if needed.

**Custom reference from column to param**

When enabled, allows you to **manually map each column** of the table to a **specific parameter**.

***

### **4. Map Columns to Parameters**

* For each column listed, choose a parameter to assign its value to.
* You can select from existing parameters.
* Only **one row** is read — usually the **first row** of the selected table.

**Example Mapping:**

| Table Column | Mapped Parameter |
| ------------ | ---------------- |
| `order_id`   | `@order_id`      |
| `region`     | `@user_region`   |
| `total_sale` | `@total_sales`   |

***

### **5. Save and Use**

* Click **Save** to include the task in your data flow.
* The captured values will now be available as **environment parameters** and can be used in:
  * SQL queries
  * Filters
  * Dashboards
  * Python or JavaScript blocks

***

#### &#x20;Use Cases

* Capture input values to personalize reporting
* Feed parameters based on outputs of tables
* Drive conditional logic based on dynamic table values
* Create reactive dashboards powered by runtime variables


---

# 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/table-to-parameters.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.