# How to change Data Types in Cascade

Having the correct data types assigned to individual columns is paramount when working with certain tools and expressions in Cascade. For instance, the [Join](/cascade/tools/combine/join.md) tool only allows users to join on columns with the same data type. Additionally, math expressions necessitate that the columns be in a numeric data type. Fortunately, the [Edit Columns](/cascade/tools/transform/editcolumns.md) tool in the Cascade tool suite makes it effortless for you to modify the data type of individual columns.

{% embed url="<https://app.arcade.software/share/haUXgu4i9unZOhachcxf>" %}

The configuration of the [Edit Columns](/cascade/tools/transform/editcolumns.md) tool permits users to select a column from the table, and edit the column name, data type, format, and description of that column. With just a few clicks, one can swiftly and easily adjust the data type of their columns, allowing them to get back to their work with a minimum of fuss. This makes the [Edit Columns](/cascade/tools/transform/editcolumns.md) tool an invaluable part of the Cascade toolkit that allows users to ensure that the correct data types are assigned to the appropriate columns.

<figure><img src="/files/OXuw0xqyzlx0IuCKISeo" alt="Add an Edit Columns tool to your workflow to change assigned data types"><figcaption><p>Add an <a href="/pages/-MYR3klipPHFAYQUwSqu">Edit Columns</a> tool to your workflow to change assigned data types</p></figcaption></figure>

{% hint style="info" %}
To select a column, utilize the column navigation arrows at the top-left corner of the tool configuration, or click the header of the column you desire to configure.
{% endhint %}

<figure><img src="/files/XTkyu8ZkeY5uxC4GqC0c" alt="Tool configuration of an Edit Columns tool and the data type menu dropdown"><figcaption><p>Tool configuration of an <a href="/pages/-MYR3klipPHFAYQUwSqu">Edit Columns</a> tool and the data type menu dropdown</p></figcaption></figure>

### Related Questions

<details>

<summary>What is the best way to change data types in Cascade?</summary>

The [Edit Columns](/cascade/tools/transform/editcolumns.md) tool in the Cascade tool suite is an excellent way to quickly and easily adjust the data type of individual columns. It allows users to select a column from the table, and edit the column name, data type, format, and description of that column. This makes it effortless for users to ensure that the correct data types are assigned to the appropriate columns.

</details>

<details>

<summary>How do I modify the data type of my columns in Cascade?</summary>

The [Edit Columns](/cascade/tools/transform/editcolumns.md) tool in the Cascade tool suite makes it easy to modify the data type of individual columns. You can select a column from the table, and edit the column name, data type, format, and description of that column. This allows you to swiftly and easily adjust the data type of your columns, so you can get back to your work with a minimum of fuss.

</details>

<details>

<summary>What are the benefits of using the Edit Columns tool in Cascade?</summary>

The [Edit Columns](/cascade/tools/transform/editcolumns.md) tool in the Cascade tool suite provides several benefits to users. It makes it easy to modify the data type of individual columns, allowing users to swiftly and easily adjust the data type of their columns, so they can get back to their work with a minimum of fuss.

Additionally, having the correct data types assigned to individual columns is paramount when working with certain tools and functions in Cascade. For instance, the [Join](/cascade/tools/combine/join.md) tool only allows users to join on columns with the same data type. Additionally, math functions necessitate that the columns be in a numeric data type. The [Edit Columns](/cascade/tools/transform/editcolumns.md) tool helps users to ensure that the correct data types are assigned to the appropriate columns.

</details>

<details>

<summary>What tools are available in Cascade to help with changing data types?</summary>

The [Edit Columns](/cascade/tools/transform/editcolumns.md) tool in the Cascade tool suite is an excellent tool for quickly and easily adjusting the data type of individual columns. It allows users to select a column from the table, and edit the column name, data type, format, and description of that column. This makes it effortless for users to ensure that the correct data types are assigned to the appropriate columns.

</details>

<details>

<summary>What is the importance of assigning the correct data types to columns in Cascade?</summary>

Having the correct data types assigned to individual columns is essential when working with certain tools and functions in Cascade. For instance, the [Join](/cascade/tools/combine/join.md) tool only allows users to join on columns with the same data type. Additionally, math functions necessitate that the columns be in a numeric data type. The [Edit Columns](/cascade/tools/transform/editcolumns.md) tool in Cascade helps users to ensure that the correct data types are assigned to the appropriate columns.

</details>

### Other Sources

{% content-ref url="/pages/-MYR3klipPHFAYQUwSqu" %}
[Edit Columns](/cascade/tools/transform/editcolumns.md)
{% endcontent-ref %}


---

# 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.cascade.io/cascade/cascade-faqs/knowledge-based/how-to-change-data-types-in-cascade.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.
