Copying, deleting, and keeping columns

• Copying columns

• Deleting columns

• Keeping columns

In Algoreus, you can copy, delete, and keep columns.

---

Copying columns

You can copy columns and add a new name to the copied column. You might want to copy a column to see the impact of using different directives on the dataset.

To copy a column, follow these steps:

1. For the column you want to copy, select the drop-down menu.

2. Select Copy column, and enter a new name for the column.

Algoreus copies the column and adds the copy directive to the recipe. When you run the data axon, the transformation will be applied to all values in the column.

---

Deleting columns

For datasets with lots of columns, delete unnecessary columns to help improve axon performance and save resources. The fewer columns, the faster the axon run completes. This is especially true for axons that include a Joiner transformation.

To delete a column from a dataset, follow these steps:

1. For the column you want to delete, select the drop-down menu.

2. Select Delete column.

Algoreus deletes the column and adds the drop directive to the recipe.

---

Keeping columns

You can keep one column in a dataset and drop the rest of the columns.

To Keep a column in a dataset, follow these steps:

1. For the column you want to keep, select the drop-down menu.

2. Select Keep column.

Algoreus deletes all columns in the dataset except the one you marked to keep and adds the keep directive to the recipe.

---