# 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**](https://docs.acho.io/acho-studio/data-prep-projects/pipeline) 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](#15-pipeline) feature to see all the actions being applied for each table in a project.

<figure><img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FSsU2YfHuuvyHH1DS5SYM%2FScreen%20Shot%202023-08-31%20at%2011.53.40%20AM.png?alt=media&#x26;token=7ffd873f-cad3-4e31-9238-8c47c1f2f2c6" 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](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/hide-columns)
* [Filter](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/filter)
* [Sort](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/sort)
* [Cut](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/cut)
* [Rename](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/rename)
* [Move Columns](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/move-column)

**Combine Table**

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

**Transformation**

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

**Data Cleaning**

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

**Tools**

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