Find, hide and show columns with the Column Browser
The Column Browser is a floating panel in the data editor for finding, hiding, showing and exploring a View's columns. Open it with the Column Browser button at the left edge of the data grid; its Column Manager renames, retypes, reorders, removes and adds columns. Both need edit access: the button is unavailable in a View-only workspace.
Open the Column Browser
- Open a View.
- Click the Column Browser button (the column icon) at the left edge of the data grid. You can also click the column count in the status bar below the grid ("12 columns", or "9 of 12 columns" when some are hidden).
The button's tooltip reads "Search and select columns to hide, show, explore, rename, reorder or retype." The panel opens as a floating dropdown with the search box ready.
Hide columns, Show columns, Show only these and Column Manager are also unavailable when:
- the grid is in edit mode or preview mode (exit it first);
- the pipeline has a task in error.
What changes affect only this View and what changes the dataset
| Change | Where | Scope |
|---|---|---|
| Hide or show columns | Column Browser or Column Manager | This View only |
| Open in Explore Columns | Column Browser | This View only |
| Rename, change type, or remove a source column | Column Manager | You choose: this View only, or the entire dataset |
| Reorder columns, add a column, change columns created by pipeline tasks | Column Manager | This View only |
| Add batch info | Column Manager | Dataset: all Views of the dataset are affected |
| Copy column names | Column Manager | Your clipboard only |
When you save a source-column change in the Column Manager, Mammoth asks Apply changes to… with This view only or Entire dataset. Changes to the entire dataset modify the dataset schema for all Views, and Mammoth warns that they may affect other Views, pipelines and connections that use the columns.
Find and select columns in the Column Browser
The panel has two sides.
- Left: the column list. At the top are a select-all checkbox, a Bulk select dropdown and a Search columns… box. Each row shows a checkbox, position number, type icon (Text, Numeric or Date, the same icons as the grid headers), column name and an eye button. Hidden columns are dimmed. A pin icon marks frozen columns, and an Explore icon marks columns that already have an Explore Card. The bottom reads "Showing all 12 columns", or "Showing 9 out of 12 columns", plus the number selected.
- Right: actions. The Actions list (Hide columns, Show columns, Show only these, Open in Explore Columns) and the Column Manager button.
Tick one or more columns to turn the actions on. Type in Search columns… to filter the list; matching text is highlighted, and "No matching columns" shows when nothing matches.
Select columns by type or visibility
Click the arrow beside the select-all checkbox (Bulk select). Each option applies to the columns currently listed, so a search narrows it.
| Option | What it does |
|---|---|
| Text, Numeric, Date (under Filter by type) | Shows only columns of that type and selects them. Choose the same type again to show all columns |
| Visible Columns | Selects the visible columns |
| Hidden Columns | Selects the hidden columns |
| Invert selection | Flips the current selection |
Hide or show columns in a View
These actions change only the current View. Hidden columns leave the grid but stay in the dataset.
| Action | What it does | Available when |
|---|---|---|
| Hide columns | Hides the selected columns | At least one selected column is visible |
| Show columns | Shows the selected hidden columns | At least one selected column is hidden |
| Show only these | Hides every column except the selected ones | One or more columns selected |
To hide or show one column, click the eye button on its row.
Open several columns as Explore Cards
Open in Explore Columns opens an Explore Card for each selected column. It adds to the cards already open rather than replacing them. It works for any column type, and it also works in edit mode and preview mode. It is unavailable when every selected column already has its card open.
Rename, retype, reorder or remove columns
Click Column Manager in the Column Browser to rename, retype, reorder or remove columns, or add batch info columns. See Rename and retype dataset columns with the Column Manager.
Troubleshooting the Column Browser
| Symptom | Cause | Fix |
|---|---|---|
| The Column Browser button is unavailable | The workspace is View-only | Ask for edit access |
| Hide, show and Column Manager are greyed out | The grid is in edit or preview mode, or a pipeline task is in error | Exit the mode, or fix the failing step |
| Open in Explore Columns is greyed out | Every selected column already has a card | Select a column without a card |
Related
- Explore Cards: what you get from Open in Explore Columns.
- Column Manager: rename, retype, reorder, remove and add columns.
- Format, rename and sort: rename and format one column from its menu.
- Fix a failing step: when a pipeline error disables column actions.
Something wrong? support@mammoth.io