AlteryxTrifacta Classic ExperienceCommon TasksCommon TasksThis section contains documentation on common methods for performing your data wrangling tasks in Designer Cloud.Import TasksImport from Another FlowImport Excel DataImport Google Sheets DataImport PDF DataCreate FlowDiscovery TasksExplore SuggestionsReview Column StatisticsAdd or Edit Recipe StepsFilter DataLocate OutliersCompute CountsCalculate Metrics across ColumnsCompare StringsAnalyze across Multiple ColumnsParse Fixed-Width File and Infer ColumnsGenerate a SampleChange Recipe Sample SizeValidation TasksProfile Your Source DataValidate Your DataValidate Column Values against a DatasetFind Bad DataFind Missing DataManage Null ValuesStructuring TasksInitial Parsing StepsTransform a ColumnTransform a RowSplit ColumnMove ColumnsAdd New ColumnDelete DataSort RowsReshaping StepsSelectCreate AggregationsNest Your DataUnnest Your DataPivot DataValues to ColumnsUnpivot ColumnsWindow TransformationsWorking with ArraysWorking with ObjectsWorking with JSON v2Working with JSON v1Cleanse TasksRename ColumnsSanitize Column NamesChange Column Data TypeCopy and Paste ColumnsCreate Column by ExampleAdd Data Quality RuleRemove DataDeduplicate DataCompare ValuesReplace Cell ValuesReplace Values Using PatternsReplace Groups of ValuesNormalize Numeric ValuesStandardize Using PatternsModify String ValuesManage String LengthsExtract ValuesFormat DatesApply Conditional TransformationsPrepare Data for Machine ProcessingEnrichment TasksCreate New ColumnAdd Two ColumnsGenerate Primary KeysAdd Lookup DataAppend DatasetsJoin DataConfigure Range JoinInsert MetadataPublishing TasksRun JobsCreate OutputsCreate Output SQL ScriptsProfile ResultsPublish Results on DemandReuse RecipeProject Management TasksTake a SnapshotTrack Data ChangesAdd Comments to Your RecipeCreate TargetOptimize Job ProcessingCreate Branching OutputsBuild Sequence of DatasetsFix Dependency IssuesShare a FlowExport FlowImport FlowReconnect Flow to Source DataReconnect Flow to OutputsCreate or Replace MacroApply a MacroCreate Flow ParameterFlag for ReviewExport DataOperationalization TasksCreate Flow Webhook TaskImport TasksImport from Another FlowImport Excel DataImport Google Sheets DataImport PDF DataCreate FlowDiscovery TasksExplore SuggestionsReview Column StatisticsAdd or Edit Recipe StepsFilter DataLocate OutliersCompute CountsCalculate Metrics across ColumnsCompare StringsAnalyze across Multiple ColumnsParse Fixed-Width File and Infer ColumnsGenerate a SampleChange Recipe Sample SizeValidation TasksProfile Your Source DataValidate Your DataValidate Column Values against a DatasetFind Bad DataFind Missing DataManage Null ValuesStructuring TasksInitial Parsing StepsTransform a ColumnTransform a RowSplit ColumnMove ColumnsAdd New ColumnDelete DataSort RowsReshaping StepsSelectCreate AggregationsNest Your DataUnnest Your DataPivot DataValues to ColumnsUnpivot ColumnsWindow TransformationsWorking with ArraysWorking with ObjectsWorking with JSON v2Working with JSON v1Cleanse TasksRename ColumnsSanitize Column NamesChange Column Data TypeCopy and Paste ColumnsCreate Column by ExampleAdd Data Quality RuleRemove DataDeduplicate DataCompare ValuesReplace Cell ValuesReplace Values Using PatternsReplace Groups of ValuesNormalize Numeric ValuesStandardize Using PatternsModify String ValuesManage String LengthsExtract ValuesFormat DatesApply Conditional TransformationsPrepare Data for Machine ProcessingEnrichment TasksCreate New ColumnAdd Two ColumnsGenerate Primary KeysAdd Lookup DataAppend DatasetsJoin DataConfigure Range JoinInsert MetadataPublishing TasksRun JobsCreate OutputsCreate Output SQL ScriptsProfile ResultsPublish Results on DemandReuse RecipeProject Management TasksTake a SnapshotTrack Data ChangesAdd Comments to Your RecipeCreate TargetOptimize Job ProcessingCreate Branching OutputsBuild Sequence of DatasetsFix Dependency IssuesShare a FlowExport FlowImport FlowReconnect Flow to Source DataReconnect Flow to OutputsCreate or Replace MacroApply a MacroCreate Flow ParameterFlag for ReviewExport DataOperationalization TasksCreate Flow Webhook Task