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