> For the complete documentation index, see [llms.txt](https://docs.acho.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions.md).

# Apply an action

## **What is an action**

In Acho Studio, you can quickly explore, clean and transform data with built-in SQL **actions**, such as sort, filter,  join, deduplicate and flatten. 

## **Action Sequence** 

In Acho Studio, all actions are performed in sequence. Once an action is applied, the resulting table will reflect a change. The change can be **reversed** when an action is **reset**. When you want to make a change to an action that you had applied several steps before, you must reset each action in between.  

The Action Sequence serves as a [**Data Pipeline**](/acho-studio/data-prep-projects/pipeline.md) in the backend. When your data source updates from either a database (e.g. MySQL, PostgreSQL) or a third-party production system (e.g.**,** Salesforce, Hubspot), the recorded action pipeline will be automatically refreshed with data updates. 

If you like to inspect your current Action Sequence, please use the [Pipeline](/acho-studio/data-prep-projects/applying-actions.md#15-pipeline) feature to see all the actions being applied for each table in a project.

<figure><img src="/files/xEQNazX98G73ZRiUkfaC" alt=""><figcaption><p>A pipeline of HubSpot data joining API data</p></figcaption></figure>

**Action Types**

Currently, Acho offers various actions to allow you to process or analyze your data.&#x20;

**View**

* [Hide Columns](/acho-studio/data-prep-projects/applying-actions/view/hide-columns.md)
* [Filter](/acho-studio/data-prep-projects/applying-actions/view/filter.md)
* [Sort](/acho-studio/data-prep-projects/applying-actions/view/sort.md)
* [Cut](/acho-studio/data-prep-projects/applying-actions/view/cut.md)
* [Rename](/acho-studio/data-prep-projects/applying-actions/view/rename.md)
* [Move Columns](/acho-studio/data-prep-projects/applying-actions/view/move-column.md)

**Combine Table**

* [Join](/acho-studio/data-prep-projects/applying-actions/combine-tables/join.md)
* [Union](/acho-studio/data-prep-projects/applying-actions/combine-tables/union.md)

**Transformation**

* [Pivot Table](/acho-studio/data-prep-projects/applying-actions/transformation/pivot-table.md)
* [Unpivot](/acho-studio/data-prep-projects/applying-actions/transformation/unpivot.md)

**Data Cleaning**

* [Cleanse](/acho-studio/data-prep-projects/applying-actions/data-cleaning/cleanse.md)
* [Replace](/acho-studio/data-prep-projects/applying-actions/data-cleaning/replace.md)
* [Change Type](/acho-studio/data-prep-projects/applying-actions/data-cleaning/change-type.md)
* [Deduplicate](/acho-studio/data-prep-projects/applying-actions/data-cleaning/deduplicate.md)
* [Split](/acho-studio/data-prep-projects/applying-actions/data-cleaning/split.md)

**Tools**

* [Formula](/acho-studio/data-prep-projects/applying-actions/tools/formula.md)
* [SQL Editor](/acho-studio/data-prep-projects/applying-actions/tools/sql-editor.md)