> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/cascade-faqs/knowledge-based/how-to-change-data-types-in-cascade.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.cascade.io/cascade/cascade-faqs/knowledge-based/how-to-change-data-types-in-cascade.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.