Alteryx Trifacta Classic Experience Common Tasks Common Tasks This section contains documentation on common methods for performing your data wrangling tasks in Designer Cloud. Import Tasks Import from Another Flow Import Excel Data Import Google Sheets Data Import PDF Data Create Flow Discovery Tasks Explore Suggestions Review Column Statistics Add or Edit Recipe Steps Filter Data Locate Outliers Compute Counts Calculate Metrics across Columns Compare Strings Analyze across Multiple Columns Parse Fixed-Width File and Infer Columns Generate a Sample Change Recipe Sample Size Validation Tasks Profile Your Source Data Validate Your Data Validate Column Values against a Dataset Find Bad Data Find Missing Data Manage Null Values Structuring Tasks Initial Parsing Steps Transform a Column Transform a Row Split Column Move Columns Add New Column Delete Data Sort Rows Reshaping Steps Select Create Aggregations Nest Your Data Unnest Your Data Pivot Data Values to Columns Unpivot Columns Window Transformations Working with Arrays Working with Objects Working with JSON v2 Working with JSON v1 Cleanse Tasks Rename Columns Sanitize Column Names Change Column Data Type Copy and Paste Columns Create Column by Example Add Data Quality Rule Remove Data Deduplicate Data Compare Values Replace Cell Values Replace Values Using Patterns Replace Groups of Values Normalize Numeric Values Standardize Using Patterns Modify String Values Manage String Lengths Extract Values Format Dates Apply Conditional Transformations Prepare Data for Machine Processing Enrichment Tasks Create New Column Add Two Columns Generate Primary Keys Add Lookup Data Append Datasets Join Data Configure Range Join Insert Metadata Publishing Tasks Run Jobs Create Outputs Create Output SQL Scripts Profile Results Publish Results on Demand Reuse Recipe Project Management Tasks Take a Snapshot Track Data Changes Add Comments to Your Recipe Create Target Optimize Job Processing Create Branching Outputs Build Sequence of Datasets Fix Dependency Issues Share a Flow Export Flow Import Flow Reconnect Flow to Source Data Reconnect Flow to Outputs Create or Replace Macro Apply a Macro Create Flow Parameter Flag for Review Export Data Operationalization Tasks Create Flow Webhook Task Import Tasks Import from Another Flow Import Excel Data Import Google Sheets Data Import PDF Data Create Flow Discovery Tasks Explore Suggestions Review Column Statistics Add or Edit Recipe Steps Filter Data Locate Outliers Compute Counts Calculate Metrics across Columns Compare Strings Analyze across Multiple Columns Parse Fixed-Width File and Infer Columns Generate a Sample Change Recipe Sample Size Validation Tasks Profile Your Source Data Validate Your Data Validate Column Values against a Dataset Find Bad Data Find Missing Data Manage Null Values Structuring Tasks Initial Parsing Steps Transform a Column Transform a Row Split Column Move Columns Add New Column Delete Data Sort Rows Reshaping Steps Select Create Aggregations Nest Your Data Unnest Your Data Pivot Data Values to Columns Unpivot Columns Window Transformations Working with Arrays Working with Objects Working with JSON v2 Working with JSON v1 Cleanse Tasks Rename Columns Sanitize Column Names Change Column Data Type Copy and Paste Columns Create Column by Example Add Data Quality Rule Remove Data Deduplicate Data Compare Values Replace Cell Values Replace Values Using Patterns Replace Groups of Values Normalize Numeric Values Standardize Using Patterns Modify String Values Manage String Lengths Extract Values Format Dates Apply Conditional Transformations Prepare Data for Machine Processing Enrichment Tasks Create New Column Add Two Columns Generate Primary Keys Add Lookup Data Append Datasets Join Data Configure Range Join Insert Metadata Publishing Tasks Run Jobs Create Outputs Create Output SQL Scripts Profile Results Publish Results on Demand Reuse Recipe Project Management Tasks Take a Snapshot Track Data Changes Add Comments to Your Recipe Create Target Optimize Job Processing Create Branching Outputs Build Sequence of Datasets Fix Dependency Issues Share a Flow Export Flow Import Flow Reconnect Flow to Source Data Reconnect Flow to Outputs Create or Replace Macro Apply a Macro Create Flow Parameter Flag for Review Export Data Operationalization Tasks Create Flow Webhook Task