> For the complete documentation index, see [llms.txt](https://docs.gaiodataos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gaiodataos.com/tools/tasks/etl/table-to-parameters.md).

# 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