Column Explorer
Note: The hidden columns will not be missed during the data export. They will be included.
To search and navigate through columns
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.
SEE ALSO
Learn more about filters in Zoho DataPrep
What are the transforms available to apply on a whole dataset?
Column-level transforms available in Zoho DataPrep
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Dataset transforms
Dataset transform consists of combining and transforming datasets to suit your needs. You can apply the following transforms in a dataset. Deduplicate Row-wise Column-wise Join Append Pivot Unpivot Calculated columns Derive dataset Mark as personal ...Duplicate Column
Zoho DataPrep allows you to duplicate columns present in your data. To duplicate columns 1. Right-click on a column header and select the Duplicate columns option from the context menu. 2. Select the columns from the Columns to duplicate dropdown. 3. ...Context menu
Zoho DataPrep offers various options in the context menu to perform column level transforms. A few basic options here are Sort, Rename, Delete and Move. To access the context menu, right click the column name and click any one of the icons to perform ...Count
DataPrep allows you to count the occurrence of data in a column based on the condition given. You can count the values that match your selection based on the different patterns that fit your selection. To count the desired value in a column 1. ...Convert units
DataPrep offers special operations to meet unique requirements with transforming data. For example, if you need to share your dataset with different regions which use different standards of measurements, you can use the Convert units special ...