# 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)


---

# 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.acho.io/acho-studio/data-prep-projects/applying-actions.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.