Hide columns¶

There may be times when you want to simply hide, but not remove, columns in a project:

• To create a personal view: You want to hide columns from the grid so they don’t clutter your view but you need to keep them in your data because they are used for calculating project steps. For example, if your work in a project is primarily with numeric columns, you could create a personal view of the data that hides all column types other than numeric.

• To publish an AnswerSet that includes only specific columns: You may want to publish a custom AnswerSet that only displays some columns from the data. First create a lens on the step where you want to create the AnswerSet, then hide the columns you do not want to show in the AnswerSet. Save the lens and your selections are saved. When you publish from the lens, only the columns you selected to show are published in the AnswerSet.

This example shows the Columns in current dataset pane with the loan_amnt and funded_amnt columns hidden:

Hide columns¶

To hide columns:

1. Click Columns in the upper right.

2. Click the eye icon on the left for any column you want to hide.

   The selected eye icons are grayed out and the selected columns no longer appear in the Preview Display.

Considerations¶

Hiding a column does not affect filters or steps in the project. As soon as you begin to make edits in the project, you automatically exit personal view mode. This means columns you hide here for your personal view are still included and displayed in the live data—with the exception of using the Lens tool because when you publish from the lens, only the columns set to show are published in the AnswerSet.

Options for hiding columns¶

• You can set options to filter the columns you want to hide. You can filter for All Columns and All Types. Use these filter menus to view only the columns that you have either selected to show or hide, and to control which column types (String, Number, DateTime) are being displayed in the View Columns pane.

• You can select a contiguous group of columns to hide. To do so, click the eye icon adjacent to the column you want to hide, then hold the Shift key and click the eye icon for the column that brackets the group you want to select.

• You can search for a column in your data. To do so, click the magnifying glass icon in the upper right of the pane and begin typing a column name.

• You can bring a column into focus on in the Preview Display. To do so, hold down the Shift key as you hover over a column name. That column then comes into view and is highlighted in the Preview Display.