DataPrep 2.0 | Data Transforms | Knowledge Base
Add prefix or suffix
Ask Zia - AI assistant to prepare data
Change case
Change data type
Change format
Change date format
Change time format
Change duration format
Cluster and merge
Context menu
Convert units
Count
Create buckets - Date
Create buckets - Number
Create buckets - Text
Duplicate column
Extract from dates
Extract from List and Map
Extract from text
Extract time
Fill empty cells
Keyword extraction
Language detection
Merge
Replace
Round off
Select transform
Smart selection
Sentiment analysis
Split
Transform by Example using ChatGPT
Trim spaces
Truncate
Unify date formats
Column explorer
Dataset transforms
Deduplicate
Join
Append
Filter
Pivot
Unpivot
Add formula
Windows functions to add formula columns
Derive dataset
Mark PII and ePHI data