How-to Guides

Discovery Tasks

• Explore Suggestions

  Learn how to explore suggestions.

• Find Missing Data

  Learn how to find missing data.

• Manage Null Values

  Learn how to manage null values.

• Find Bad Data

  Learn how to find bad data.

• Locate Outliers

  Learn how to locate outliers.

• Analyze across Multiple Columns

  Learn how to analyze data across multiple columns.

• Calculate Metrics across Columns

  Learn how to calculate metrics across columns.

• Import Excel Data

  Learn how to import Excel data.

• Parse fixed-width files and infer columns

  Learn how to parse fixed-width files and infer columns.

• Filter Sampled Data

  Learn how to filter sampled data.

Cleanse Tasks

• Remove Data

  Learn how to remove data.

• Normalize Values

  Learn how to normalize values.

• Match Text Values

  Learn how to match text values.

• Manage String Lengths

  Learn how to manage string lengths.

• De-duplicate Data

  Learn how to de-duplicate data.

• Rename a Column

  Learn how to rename a column.

• Add or Edit Recipe Steps

  Learn how to add or edit recipe steps.

• Standardize Non-Numeric Values

  Learn how to standardize non-numeric values.

• Compare Values

  Learn how to compare values.

• Apply Conditional Transformations

  Learn how to apply conditional transformations.

Enrichment Tasks

• Add Headers to Your Columns

  Learn how to Add headers to your columns.

• Add Lookup Data

  Learn how to add lookup data.

• Generate Primary Keys

  Learn how to generate primary keys.

• Append Datasets

  Learn how to append datasets.

• Insert Metadata

  Learn how to insert metadata.

• Edit a Join

  Learn how to edit a join.

• Enrich Data

  Learn how to enrich data.

• Add Two Columns

  Learn how to add two columns.

Project Management Tasks

• Overview

  Learn how to manage your Cloud Dataprep project.

• Profile Your Source Data

  Learn how to profile your source data.

• Validate Your Data

  Learn how to validate your data.

• Track Column Changes

  Learn how to track column changes.

• Build Sequence of Datasets

  Learn how to build a sequence of datasets.

• Fix Dependency Issues

  Learn how to fix dependency issues.

• Optimize Job Processing

  Learn how to optimize job processing.

• Add Comments to your Recipe

  Learn how to add comments to your recipe.

• Take a Snapshot

  Learn how to take a snapshot of your work.

• Run a Job on Cloud Dataflow

  Learn how to run a job on Cloud Dataflow.

• Track Data Changes

  Learn how to track data changes.