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.

• Create a Dataset with Parameters

  Learn how to create a dataset with parameters.

Cleanse Tasks

• Remove Data

  Learn how to remove data.

• Normalize Numeric Values

  Learn how to normalize numeric values.

• Compare Strings

  Learn how to compare strings.

• Manage String Lengths

  Learn how to manage string lengths.

• Replace Values

  Learn how to replace values.

• Extract Values

  Learn how to extract values.

• Format Dates

  Learn how to format dates.

• 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 Using Patterns

  Learn how to standardize using patterns.

• Compare Values

  Learn how to compare values.

• Apply Conditional Transformations

  Learn how to apply conditional transformations.

• Prepare Data for Machine Processing

  Learn how to prepare data for machine processing.

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.

• Create Aggregations

  Learn how to create aggregations.

• Pivot Data

  Learn how to pivot data.

• 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.

• 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.

• Create Target

  Learn how to associate a target with a recipe.

• Take a Snapshot

  Learn how to take a snapshot of your work.

• Track Column Changes

  Learn how to track column changes.

• Track Data Changes

  Learn how to track data changes.

• Run a Job on Cloud Dataflow

  Learn how to run a job on Cloud Dataflow.

• Diagnose Failed Jobs

  Learn how to diagnose failed jobs.

• Schedule a Job

  Learn how to schedule a job.

• Create Branching Outputs

  Learn how to create branching outputs.

• Send a Copy of a Flow

  Learn how to send a copy of a flow.

• Share a Flow

  Learn how to share a flow.

• Export a Flow

  Learn how to export a flow.

• Import a Flow

  Learn how to import a flow.