# Add Column

In this document, you will explore how to add a column in Astera Dataprep.

1. To add a column, click *Layout* in the toolbar and select *Add Column.*

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FfT1uBeO9VrCRLdtRJrBj%2F0.png?alt=media" alt=""><figcaption></figcaption></figure>

2. Once done, the *Recipe Configuration – Add Column* panel will open.

![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FhVJV7JKqkBVmSHMAS40x%2F1.png?alt=media)

3. In this panel, you can specify the *Name, Type, Header, Position,* and *Index.*

![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2Fg7xw3Q4dtylDCqr4A1TU%2F2.png?alt=media)

* **Name:** The name of the new column.
* **Type:** The datatype of the new column to be added.
* **Header:** Specifies the column name when writing to a file.
* **Position:** Consists of various options to help specify where the new column should be added.
  * **Index:** Adds the column at the specified Index position.
  * **Start:** Adds a column to the start of the dataset.
  * **End:** Adds a column to the end of the dataset.
  * **Move Before:** Adds a column before a specified column in the dataset. Once selected, you must specify the column through the Reference drop-down.
  * **Move After:** Adds a column after a specified column in the dataset. Once selected, you must specify the column through the Reference drop-down.

![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FpXY0NxbgoiEPI3oCXVIO%2F3.png?alt=media)

* **Value:** You can specify the expression that you want to be applied on the objects for the new column.
  * This can be done directly in the expression box, or you can open the *Expression Builder* by clicking ![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FNEDqydPib8PgrV5WySDO%2F3.png?alt=media) next to the expression box.
  * Here, we have simply added 100 to our existing ‘*Freight*’ value.

![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2Fx2sja6rLEXAKlLLLDxlH%2F4.png?alt=media)

4. Now, let’s select *Apply* ![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2F7VsSbSLkUrOXP5XbWHhi%2F4.png?alt=media) to add this new column to our dataset.
5. Once done, you can see that the new column with your specified configurations has been added to the grid.

![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FVOh6wmzxK2bMWdFQ5gVo%2F6.png?alt=media)