Hide a Column in a Dataset

In a dataset you can hide a column so that workbook users can't access that column in any visualization, calculation, or filter that uses the dataset. You can unhide columns if needed.

Hiding a column in a dataset enables you to:
  • Prevent the use of sensitive, irrelevant, or deprecated data fields.
  • Support data governance and, enforce privacy or compliance.
Hidden columns are available for table joins, whereas deleted columns aren't. See Delete a Column in a Dataset.
  1. On your home page, hover over a dataset that you own, click Actions Icon for Actions menu, and then select Open
    Description of open-dataset.png follows
    Description of the illustration open-dataset.png

    .
    If the dataset contains a single table, you'll see the transform editor. If the dataset contains multiple tables, you'll see the Join Diagram. In the Join Diagram, right-click a data source and click Open to display the transform editor.
  2. In the transform editor, hover over the column that you want to hide and click Options Options ellipsis icon.in the column header.
    Description of column-options-menu.png follows
    Description of the illustration column-options-menu.png

  3. Select Hide.
    A new data transform step named Hide Column <Column name> is added to the Preparation Script. To undo, delete this step.