Column Explorer

The Column Explorer in Zoho DataPrep allows you to search, navigate and control the viewing options of the columns in a dataset. You can search and filter columns with invalid or missing data and fix them quickly. This helps you focus on the columns that matter.

Note: The hidden columns will not be missed during the data export. They will be included.

To search and navigate through columns

1. Click the Column Explorer icon

from the top right corner of the Studio page.

2. In the Column Explorer panel, enter the required column name in the search bar.

4. Click on the column name to navigate to the column.

5. Once you have navigated to the required column successfully, you can perform the desired actions over the column.

To hide or show columns

1. Click the Column Explorer icon from the top right corner of the Studio page.

2. Click on the eye icon to Hide/show columns in the list of columns shown in the Column Explorer panel.

3. You can show or hide all the columns, or, filter columns with invalid or missing data using the Columns drop down. Expand the Columns drop down and choose one of the quick actions listed below:

Show all - This options helps you show all the columns in the dataset.

Hide all - This option allows you to hide all the columns in the dataset.

Show only columns with invalid data - This option helps you filter those columns with invalid data in your dataset.

Show only columns with missing data - This option helps you filter those columns with missing data in your dataset.

5. Click Apply to view the required columns.

For example, in the below screenshot, columns with missing data is shown by filtering using the missing data option.

What are the transforms available to apply on a whole dataset?

Column-level transforms available in Zoho DataPrep

How to navigate, show/hide, and filter columns in Zoho DataPrep?

Column Explorer

To search and navigate through columns

To hide or show columns