> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-pipeline/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/data-pipeline/~/changes/BozVtU3tL5BwgOHeoMZt/jobs/transformations.md).

# Transformations

This page aims to explain the various transformation option provided on the Jobs Editor page.

The following transformations are provided under the ***Transformations*** section.

1. Alter Columns
2. Select Columns
3. Date Formatter
4. Query
5. Filter
6. Formula
7. Join
8. Aggregation
9. Sort Task

### **Alter Columns**

The ***Alter Columns*** command is used to change the data type of a column in a table.

#### **Meta Information** 

Add the Column name from the ***Alter Columns*** tab where the datatype needs to be changed.

* **Name** (\*): Column name.
* **Alias Name(**\*) : New column name.
* **Column Type**(\*): Specify datatype from dropdown.
* **Add New Column:** Multiple columns can be added for desired modification in the datatype.

### **Select Columns**

Helps to select particular columns from a table definition.

#### **Meta Information**

* **Name** (\*): Column name.
* **Alias Name**(\*) : New column name.
* **Column Type**(\*) : Specify datatype from dropdown.
* **Add New Column**: Multiple columns can be added for the desired result

### **Date Formatter** 

It helps in converting Date and Datetime columns to a desired format.

**Meta Information**

* **Name** (\*): Column name.
* **Input Format**(\*) : The function has total 61 different formats.
* **Output Format**(\*): The format in which the output will be given.
* **Output Column Name**(\*): Name of the output column.
* **Add New Row**: To insert a new row.

### **Query**

The Query transformation allows you to write SQL (DML) queries such as Select queries and data view queries.

**Meta Information**

* **Query**(\*): Provide a valid query to transform data.
* **Table Name**(\*): Provide the table name.
* **Schema File Name**: Provide schema file name. 
* **Choose File**: Upload a file from the system.

{% hint style="info" %}
*<mark style="color:green;">Please Note</mark>: Alter query will not work.*
{% endhint %}

### **Filter**

The Filter columns allow the user to filter table data based on different defined conditions.

#### **Meta Information**

* **Field Name**(\*): Provide field name.
* **Condition** (\*): 8 condition operations are available within this function.
* **Logical Condition**(\*)(AND/OR):&#x20;
* **Add New Column:** Adds a new Column.&#x20;

### **Formula**

It gives computation results based on the selected formula type.

**Meta Information**

* **Field Name**(\*): Provide field name.
* **Formula Type**(\*): Select a Formula Type from the drop-down option.
  * Math (22 Math Operations)
  * String (16 String Operations )
  * Bitwise (3 Bitwise Operations)
* **Output Field Name(\*):** Provide the output field name.
* **Add New Column:** Adds a new column.

### **Join**&#x20;

It joins 2 tables based on the specified column conditions.

**Meta Information :**

* **Join Type** (\*): Provides drop-down menu to choose a Join type.
  * The supported Join Types are:
    * Inner
    * Outer
    * Full
    * Full outer
    * Left outer
    * Left
    * Right outer
    * Right
    * Left semi
    * Left anti
* **Left Column**(\*): Conditional column from the left table.
* **Right Column**(\*) : Conditional column from right table.
* **Add New Column**: Adds a new column.

### **Aggregation**

An aggregate task performs a calculation on a set of values and returns a single value by using the ***Group By*** column.

**Meta Information**

* **Group By Columns**(\*): Provide a name for the group by column.
* **Field Name**(\*): Provide the field name.
* **Operation** (\*): 30 operations are available within this function.
* **Alias**(\*): Provide an alias name.
* **Add New Column**: Adds a new column.

### **Sort Task**

This transformation sorts all the data from a table based on the selected column and order.

**Meta Information**

* **Sort Key**(\*): Provide a sort key.
* **Order**(\*): Select an option out of **Ascending** or **Descending**.
* **Add New Column**: Adds a new column.

<figure><img src="https://363587200-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fuq3RSHHup7fjHYaspk7y%2Fuploads%2FWSRLa24cdg3V4u9r3C5Z%2Fimage.png?alt=media&amp;token=1693dff4-6918-49a1-aef4-a1b3aaa9dcb0" alt=""><figcaption></figcaption></figure>