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.

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

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

• 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.

• 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 next to the expression box.

  • Here, we have simply added 100 to our existing ‘Freight’ value.

1. Now, let’s select Apply to add this new column to our dataset.

2. Once done, you can see that the new column with your specified configurations has been added to the grid.