Select Columns

Choose the columns you keep. Set the order they appear in.

What it does

Select Columns keeps only the columns you pick. Every other column leaves the table. You also control the left-to-right order of the columns you keep.

Pick your columns

  1. Type select in the Search transforms box, in the Pipeline panel.
  2. Click Select Columns in the results. The panel opens below the grid.
  3. Click the box under Select columns. The column list drops down.
  4. Type part of a name to shorten the list.
  5. Click a column to add it. A tick marks the columns you added.
  6. Repeat for each column you want to keep.
  7. Click Apply.

Each column you add becomes a small chip inside the box. Click the x on a chip to drop that column again.

Set the order

A Column order list appears under the picker after your first pick. Each row shows a position number and a column name.

  • Click the up arrow on a row to move that column one place earlier.
  • Click the down arrow to move it one place later.
  • The arrows are inactive at the top and the bottom of the list.

Try it on an orders file. Keep order_id, customer_name and order_total. Then move order_total to position 1. The money column now sits first in the grid.

Good to know

  • If you click Apply with no column selected, the panel shows an error.
  • The step appears in the Pipeline. Use Edit step to change your picks later.
  • Use Delete step to remove the step. All the original columns come back.

For SQL users

The step names your columns in the order you set:

SELECT "order_id", "customer_name", "order_total" FROM "orders"
Try Select Columns with sample data →

Related Operations