GCP Cloud DataPrep

Cleanse Task

Discovery Task

Enrichment Task

Import Task

Project Management Task

Publishing Task

Structring Task

Validation Task

Apply Conditional Transformations

Def : In your recipe steps, you can apply conditional logic to determine if transformational changes should occur.

Properties

Single- and multi-case transformations

Change Column Data Type

DEF : While transforming your data, you may need to change the data type of one or more columns.

Compare Values

Def : Depending on the data type, you can compare values in separate columns or single columns against fixed values.

Replace Cell Values

Def : You can search and replace for specific values in a column.

Copy and Paste Columns

Def : You can cut, copy, and paste columns or column values in your dataset through the Column Browser panel or the column menus in the data grid.

Deduplicate Data

By Extract

Format Dates

Manage String Lengths

Modify String Values

Normalize Numeric Values

Prepare Data for Machine Processing

Remove Data

Rename Columns

Replace Groups of Values

Standardize Using Patterns