Skip to main content Skip to complementary content

Columns functions

These functions are available from the functions list, as well as the menu in the header of a given column. If it is the latter, click Menu and select the function to apply.

Create new column

Creates a new column in the table.

Properties

Property Configuration
New column name

Enter the name you want to give the new column. If you do not specify a name, the default name of the new column will be new_column_name

Anchor column

From the drop-down list, select the column next to which the new column will be created.

Right of anchor Use this toggle to select if you want to create the new column on the left or right of the anchor column. Leave the toggle selected to create it on the right, unselect it to create it on the left.
Fill column with

From the drop-down list, select if you want the cells of new column to contain predefined values or a specific one.

  • Empty: The column will only contain empty values.

  • NULL: The column will only contain NULL values.

  • Value: Use this option to freely set a specific value for the column cells, in the Value field.

  • Sequence: The column will be filled with a sequence of numbers. Set a Start value and a Step value to decide the incrementation.

Information noteApplied filters are not taken into account when using this function.

Delete column

Deletes a column from the table.

Properties

Property Configuration
Columns to process

Select the column or columns you want to remove.

If you want to delete more than one column, use the drop-down list to select which columns, and click Apply.

Duplicate column

Duplicates a column and its content.

Properties

Property Configuration
Columns to process

Select the column or columns you want to duplicate.

If you want to duplicate more than one column, use the drop-down list to select which columns, and click Apply.

New column name

Enter the name you want to give the new column. If you do not specify a name, the default name of the new column will be <column_name>_copy.

Information noteApplied filters are not taken into account when using this function.

Rename column

Renames a column.

Properties

Property Configuration
Column to rename

Use the drop down list to select the column to rename.

New column name

Enter the new name you want to give the column. The default name of the new column will be <column_name>_renamed.

Reorder column

Moves a column to a new place in the table.

Properties

Property Configuration
Column

Use the drop down list to select the column to move.

Anchor column

From the drop-down list, select the column next to which the selected column will be moved.

Right of anchor Use this toggle to select if you want to move the selected column on the left or right of the anchor column. Leave the toggle selected to move it to the right, unselect it to move to the left.
Tip noteAlternatively, you can reorder your columns in the table using drag and drop on a column header.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!