Skip to main content
The Columns tool is probably the most used tool in Less. It is quite a swiss army knife that can be used for a number of things: changing the order of your columns, selecting a subset of the columns you want to keep in your dataset, renaming column names and changing the data types of your columns.

​
Configuration

The Columns tool consists of one required input and three optional.
1

Select Columns

It is mandatory to select minimum one column to keep in your dataset. You can use the checkboxes to the left of the column name to keep the given column.
You can select/deselect all columns with the checkbox in the header row of the configuration window
2

Optional: Rename Columns

You can rename your column names in by entering a new name in the “Rename Column” tab in the configuration windows. This is optional.
3

Optional: Order Columns

You can change the order of when your column appears in your dataset. For instance, you might want your ID columns to be the first in your dataset. You can change the order by dragging the given column up or down with the drag button all the way to the left in the configuration window.
4

Optional: Change Column Data type

You can change the column data type in the dropdown to the right in the configuration windows. For instance, changing a text/string column to a decimal/float data type.

​
Configuration overview

Here you can view each of the options in the configuration window.
  1. Select all columns
  2. Deselect all columns
  3. Show selected columns
  4. Search for a column
  5. Drag this to reorder the columns
  6. Move a column to the top
  7. Check this to select the column
  8. Rename the column
  9. Change the data type of the column