Text |
Numeric |
Datetime |
Duration |
Boolean |
List |
Map |
contains |
=equal to |
= equal to |
is smallest |
is true |
has value |
has key |
doesn't contain |
!= not equal to |
!= not equal to |
is largest |
is false |
is empty list |
is empty map |
begins with |
> more than |
is earliest |
= equal to |
contains |
is not empty list |
is not empty map |
ends with |
< less than |
is latest |
!= not equal to |
doesn't contain |
is cell empty |
is cell empty |
is |
>= more than or equal |
is after |
is cell empty |
begins with |
is cell not empty |
is cell not empty |
is not |
<= less than or equal to |
is before |
is cell not empty |
ends with |
use regex |
use regex |
is cell empty |
is smallest |
on or after |
use regex |
is |
use patterns |
use patterns |
is cell not empty |
is largest |
on or before |
use patterns |
is not |
|
|
use regex |
is cell empty |
is cell empty |
|
is cell empty |
|
|
use patterns |
is cell not empty |
is cell not empty |
|
is cell not empty |
|
|
|
use regex |
use regex |
|
use regex |
|
|
|
use patterns |
use patterns |
|
use patterns |
|
|
Datatype
|
Functions
|
Number
|
Sum
Maximum
Minimum
Average
Standard deviation
Median
Mode
Percentile
Variance
Count
Distinct count
|
Text
|
Count
Distinct count
|
Date
|
Count
Distinct count
Maximum date
Minimum date
|
List
|
Count
Distinct count
|
Map
|
Count
Distinct count |
2. Add personal data columns to in the Mark columns with personal data section.
3. Click
Apply
to
mark the
selected
columns as personal data.
1. Click the Export now option from the Export menu in the DataPrep Studio page.
1. Data masking
Data masking hides original data with 'x' to protect personal information.
2. Data Tokenization
Data tokenization replaces each distinct value in your data with a random value. Hence the output is statistically identical to the original data.
3. None
You can select None if you do not want to use any security method.
![]()
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
Write to us: support@zohoforms.com