Move Column

In this document, you will explore how to move a column to a new position in Astera Dataprep.

1. To move a column in Astera Dataprep you can click on the Layout option in the toolbar and select Move Column from the drop-down.

Alternatively, you can also right-click on the column header that you want to move to a new position and select Move Column and the required position from the drop-down.

1. Once selected, the Recipe Configuration – Move Column panel will open. Here, you can specify the Name and Position of the column.

• Position: Consists of various options which can be selected to move columns to different positions.

  • Start: Moves the column to the start of the dataset.

  • End: Moves the column to the end of the dataset.

  • Right Displacement: Moves the column to the right by the specified number of Index times.

  • Left Displacement: Moves the column to the left by the specified number of Index times.

  • Index: Moves the column to the specified Index position.

  • Move Before: Moves a column before a specified column in the dataset. Once selected, you must specify the column through the Referenced Column drop-down.

  • Move After: Moves a column after a specified column in the dataset. Once selected, you must specify the column through the Referenced Column drop-down.

1. Once the necessary configurations have been made, you can select Apply to move the column to your desired position.

1. You can also move a column within the Grid itself. To do this, you simply drag-and-drop the column to a new position. When dragging a column, a black line appears to indicate the drop position.