◄Show Table of Contents

Sample Workflows

Designer contains a number of sample workflows to demonstrate tool functionality and use cases. Sample workflows can be accessed from the main menu by clicking Help > Sample Workflows. Workflows below are listed alphabetically by directory and list the tools contained in each sample.

ClosedLearn one tool at a time
ClosedAction.yxwz
Action, Browse, Check Box, Comment, Detour, File Browse, Filter, Formula, Input Data, Label, Link, List Box, Map, Map Input, Numeric Up Down, Radio Button, Sample, Select, Sort, Tab, Text Box, Text Input, Tool Container, Trade Area
ClosedAppend.yxmd
Append Fields, Comment, Input Data
ClosedAuto_Field.yxmd
Auto Field, Comment, Input Data
ClosedBrowse.yxmd
Browse, Comment, Input Data
ClosedCheck_Box.yxwz
Action, Browse, Check Box, Comment, Group, Label, Radio Button, Tab, Text Input, Tool Container
ClosedComment.yxmd
Comment
ClosedCondition.yxwz
Action, Browse, Comment, Condition, Formula, Label, Radio Button, Tab, Text Input
ClosedCount_Records.yxmd
Comment, Count Records, Input Data
ClosedCross_Tab.yxmd
Comment, Cross Tab, Input Data, Text Input, Transpose
ClosedData_Cleansing.yxmd
Comment, Data Cleansing, Text Input
ClosedDate.yxwz
Action, Browse, Comment, Date, Filter, Generate Rows, Tab
ClosedDateTime.yxmd
Comment, DateTime, Select, Text Input
ClosedDirectory.yxmd
Comment, Directory
ClosedDistance.yxmd
Comment, Distance, Text Input, Tool Container
ClosedDrop_Down.yxwz
Action, Browse, Comment, Drop Down, Dynamic Select, File Browse, Input Data, Label, Link, Radio Button, Tab, Tool Container
ClosedDynamic_Rename.yxmd
Comment, Dynamic Rename, Text Input
ClosedDynamic_Replace.yxmd
Comment, Dynamic Replace, Text Input
ClosedDynamic_Select.yxmd
Comment, Dynamic Select, Text Input
ClosedError_Message.yxwz
Browse, Check Box, Comment, Error Message, Tab, Text Input, Tool Container
ClosedExplorer Box.yxmd
Comment, Explorer Box
ClosedField_Summary.yxmd
Browse, Comment, Input Data
ClosedFile_Browse.yxwz
Action, Browse, Comment, Condition, Error Message, File Browse, Input Data, Label, Link, Output Data, Radio Button, Render, Tab, Table, Tool Container
ClosedFilter.yxmd
Comment, Filter, Formula, Generate Rows, Join Multiple, Text Input, Tool Container
ClosedFind_Replace.yxmd
Comment, Find Replace, Text Input
ClosedFormula.yxmd
Comment, Formula, Input Data
ClosedFuzzy_Match.yxmd
Comment, Explorer Box, Find Replace, Fuzzy Match, Make Group, Summarize, Text Input
ClosedGenerate_Rows.yxmd
Comment, Generate Rows, Text Input
ClosedImage.yxmd
Browse, Comment, Directory, Image, Text Input
ClosedImputation.yxmd
Comment, Imputation, Text Input
ClosedInput_Data.yxmd
Comment, Input Data
ClosedJoin.yxmd
Comment, Join, Text Input, Union
ClosedJoin_Multiple.yxmd
Comment, Join, Join Multiple, Text Input, Union
ClosedList_Box.yxwz
Action, Browse, Comment, Dynamic Select, File Browse, Input Data, Label, Link, List Box, Radio Button, Select, Tab, Tool Container
ClosedMake_Group.yxmd
Comment, Find Replace, Fuzzy Match, Make Group, Summarize, Text Input
ClosedMap.yxwz
Action, Browse, Comment, File Browse, Label, Map, Map Input, Radio Button, Tab, Tool Container
ClosedMap_Input.yxmd
Browse, Comment, Map Input
ClosedMap_Legend_Splitter_Builder.yxmd
Browse, Comment, Formula, Input Data, Map Legend Builder, Map Legend Builder, Map Legend Splitter, Map Legend Splitter, Report Map
ClosedMulti-Field_Binning.yxmd
Comment, Multi-Field Binning, Text Input
ClosedMulti-Field_Formula.yxmd
Comment, Input Data, Multi-Field
ClosedMulti-Row_Formula.yxmd
Comment, Cross Tab, Multi-Row Formula, Text Input
ClosedNumeric_Up_Down.yxwz
Browse, Comment, Filter, Generate Rows, Numeric Up Down, Tab
ClosedOutput_Data.yxmd
Comment, Output Data, Text Input
ClosedPearson_Correlation.yxmd
Comment, Formula, Pearson Correlation, Spearman Correlation, Text Input
ClosedRadio_Button.yxwz
Action, Browse, Comment, Label, Radio Button, Tab, Text Input
ClosedRandom % Sample.yxmd
Comment, Input Data, Random % Sample, Sample
ClosedRecord_ID.yxmd
Comment, Record ID, Text Input
ClosedRegEx.yxmd
Comment, Input Data, RegEx, Tool Container
ClosedRender.yxmd
Comment, Input Data, Render, Report Footer, Report Footer, Report Header, Report Header, Report Text
ClosedReport_Footer.yxmd
Browse, Comment, Join Multiple, Layout, Render, Report Footer, Report Text
ClosedReport_Header.yxmd
Browse, Comment, Join Multiple, Layout, Render, Report Header, Report Text
ClosedReport_Map.yxmd
Browse, Comment, Input Data, Report Map, Select, Text Input
ClosedReport_Text.yxmd
Browse, Comment, Report Text, Text Input
ClosedRunning_Total.yxmd
Comment, Input Data, Running Total
ClosedSample.yxmd
Comment, Input Data, Sample
ClosedSelect.yxmd
Comment, Input Data, Select
ClosedSelect_Records.yxmd
Comment, Input Data, Select Records
ClosedSort.yxmd
Comment, Sort, Text Input
ClosedSpearman_Correlation.yxmd
Comment, Formula, Pearson Correlation, Spearman Correlation, Text Input
ClosedSummarize.yxmd
Comment, Input Data, Summarize
ClosedTable.yxmd
Browse, Comment, Cross Tab, Input Data, Table
ClosedTest.yxmd
Comment, Input Data, Test
ClosedText_Box.yxwz
Action, Browse, Comment, Label, Radio Button, Tab, Text Box, Text Input, Text To Columns, Tool Container
ClosedText_Input.yxmd
Comment, Text Input
ClosedText_To_Columns.yxmd
Comment, Input Data, Text To Columns
ClosedTile.yxmd
Comment, Input Data, Tile
ClosedTranspose.yxmd
Comment, Cross Tab, Text Input, Transpose
ClosedTree.yxwz
Action, Browse, Comment, Condition, Error Message, Filter, Input Data, Join, Radio Button, Tab, Text Input, Text To Columns, Tool Container, Tree
ClosedUnion.yxmd
Comment, Join, Text Input, Union
ClosedUnique.yxmd
Comment, Input Data, Unique
ClosedXML_Parse.yxmd
Comment, Input Data, Sort, XML Parse
ClosedClean and prepare data
Closed01 Normalize_a_string_field.yxmd
Browse, Comment, Formula, Input Data, RegEx, Text To Columns, Tool Container
Closed02 Convert_data_types_with_Auto-Field.yxmd
Auto Field, Browse, Comment, Field Info, Input Data, Select, Tool Container
Closed02 Normalize_phone_numbers.yxmd
Browse, Comment, Filter, Formula, Input Data, RegEx, Select, Tool Container
Closed03 Measure_the_quality_of_data.yxmd
Append Fields, Browse, Comment, Formula, Input Data, Message, Sort, Summarize, Tool Container, Transpose
Closed03 Normalize_an_unstructured_.txt_file.yxmd
Browse, Comment, Cross Tab, Filter, Formula, Input Data, Join, Multi-Row Formula, RegEx, Select, Summarize, Text To Columns, Tool Container, Transpose
Closed04 Append_a_leading_character.yxmd
Browse, Comment, Formula, Input Data, Tool Container
Closed04 Normalize_an_unstructured_.xml_file.yxmd
Browse, Comment, Input Data, Select, Tool Container, XML Parse
Closed05 Infer_ZIP_codes_from_latitude_and_longitude.yxmd
Browse, Comment, Dynamic Input, Input Data, Tool Container
Closed07 Smooth_spatial_objects_on_a_map.yxmd
Buffer, Comment, Create Points, Generalize, Input Data, Render, Report Map, Report Text, Smooth, Text Input, Tool Container, Trade Area
Closed08 Create_an_.xml_file.yxmd
Browse, Comment, Formula, Join, Output Data, Summarize, Text Input, Tool Container, Union
ClosedDescribe what is happening
Closed01 Create_service_boundaries.yxmd
Browse, Comment, Create Points, Distance, Formula, Input Data, Join, Select, Spatial Match, Summarize, Tool Container, Trade Area, Union
Closed01 Join_data_from_two_sources.yxmd
Browse, Comment, Formula, Input Data, Join, Summarize, Tool Container
Closed02 Join_data_from_multiple_sources.yxmd
Browse, Comment, Input Data, Join Multiple, Tool Container
Closed02 Learn_frequently-used_tools.yxmd
Browse, Comment, Filter, Formula, Input Data, Join, Record ID, Sample, Select, Sort, Summarize, Text Input, Tool Container, Union, Unique
Closed03 Group_sales_by_county.yxmd
Browse, Comment, Formula, Input Data, Select, Summarize, Tool Container
Closed03 Join_rows_with_Union.yxmd
Browse, Comment, Input Data, Record ID, Tool Container, Union
Closed03 Map_trade_areas_1.yxmd
Comment, Create Points, Filter, Find Nearest, Formula, Input Data, Join, Poly-Build, Record ID, Render, Report Map, Sort, Summarize, Tile, Tool Container
Closed04 Find_all_customers_within_30_miles_of_a_store.yxmd
Browse, Comment, Create Points, Distance, Input Data, Join, Select, Sort, Spatial Match, Summarize, Tool Container, Trade Area
Closed04 Map_trade_areas_2.yxmd
Comment, Create Points, Input Data, Render, Report Map, Report Text, Select, Tool Container, Trade Area
Closed05 Download_and_parse_web_data.yxmd
Auto Field, Browse, Comment, Create Points, Date Time Now, DateTime, Download, Dynamic Rename, Formula, Join, Layout, Message, Multi-Field, Render, Report Map, Report Text, Sample, Select, Sort, Table, Text Input, Text To Columns, Tool Container
Closed05 Overlay_a_zip_code_map_1.yxmd
Browse, Comment, Input Data, Report Map, Spatial Match, Tool Container
Closed06 Create_a_report_with_a_chart_and_a_table.yxmd
Charting, Comment, Image, Input Data, Join Multiple, Layout, Render, Report Text, Sort, Table, Tool Container
Closed06 Overlay_a_zip_code_map_2.yxmd
Browse, Comment, Formula, Input Data, Join, Spatial Info, Summarize, Tool Container
Closed07 Create_summary_tables_for_a_report.yxmd
Comment, Cross Tab, Image, Input Data, Join Multiple, Layout, Render, Report Text, Select, Summarize, Table, Tool Container
Closed07 Measure_the_overlap_of_ad_coverage.yxmd
Browse, Comment, Create Points, Formula, Input Data, Select, Spatial Info, Spatial Match, Spatial Process, Tool Container, Trade Area
Closed08 Make_a_contingency_table.yxmd
Browse, Comment, Cross Tab, Input Data, Select, Summarize, Tool Container
Closed09 Read_a_.flat_file.yxmd
Browse, Comment, Filter, Input Data, Tool Container
Closed10 Create_tables_from_unicode_data.yxmd
Charting, Comment, Image, Join, Join Multiple, Layout, Render, Report Text, Table, Text Input, Tool Container
Closed11 Create_a_report_layout.yxmd
Charting, Comment, Image, Input Data, Join Multiple, Layout, Render, Report Footer, Report Map, Report Text, Summarize, Table, Tool Container
ClosedDiagnose why it is happening
Closed01 Append_a_calculated_field.yxmd
Append Fields, Browse, Comment, Formula, Input Data, Summarize, Tool Container, Unique
Closed02 Apply_a_formula_to_multiple_fields.yxmd
Browse, Comment, Input Data, Multi-Field, Select, Tool Container
Closed03 Find_the_closest_stores_to_customers.yxmd
Browse, Comment, Create Points, Find Nearest, Input Data, Select, Summarize, Tool Container
Closed04 Create_a_report_with_a_thematic_map.yxmd
Append Fields, Comment, Create Points, Formula, Input Data, Layout, Map Legend Builder, Map Legend Builder, Map Legend Builder, Map Legend Builder, Map Legend Splitter, Map Legend Splitter, Map Legend Splitter, Map Legend Splitter, Render, Report Footer, Report Footer, Report Footer, Report Footer, Report Header, Report Header, Report Header, Report Header, Report Map, Report Text, Spatial Match, Summarize, Tool Container
Closed06 Group_data_and_calculate_a_trend.yxmd
Browse, Comment, Filter, Formula, Input Data, Join Multiple, Sample, Sort, Tile, Tool Container
ClosedUse scripting and automation tools
Closed01 StrongADD_FuzzyFL.yxmc
Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Select, Sort, Tab, Tool Container, Union, Unique
Closed02 Convert_file_formats.yxwz
Action, Comment, Error Message, File Browse, Input Data, Output Data, Tab, Tool Container
Closed02 StrongADD_FuzzyLF.yxmc
Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Select, Sort, Tab, Tool Container, Union, Unique
Closed03 Assign_supply_to_demand.yxmd
Append Fields, Browse, Comment, Distance, Input Data, Record ID, Select, Sort, Summarize, Test, Tool Container
Closed03 Clean_and_parse_phone_numbers.yxwz
Action, Comment, Condition, Error Message, File Browse, Filter, Formula, Input Data, List Box, Output Data, Radio Button, RegEx, Select, Tab, Tool Container, Union
Closed03 StrongFL_FuzzyADD.yxmc
Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Select, Sort, Tab, Tool Container, Union, Unique
Closed04 Define_trade_areas.yxwz
Action, Comment, Create Points, File Browse, Filter, Find Nearest, Formula, Input Data, Join, Label, Numeric Up Down, Poly-Build, Record ID, Render, Report Map, Sort, Summarize, Tab, Tile, Tool Container
Closed04 Map_customers_by_store.yxmd
Comment, Create Points, Find Nearest, Input Data, Join, Pie Wedge Trade Area, Record ID, Render, Report Map, Report Text, Tool Container
Closed04 StrongADD_FuzzyFL_Char.yxmc
Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Select, Sort, Tab, Tool Container, Union, Unique
Closed05 Create_a_heat_map_for_purchase_data.yxmd
Comment, Create Points, Heat Map, Input Data, Render, Report Map, Report Text, Tool Container
Closed05 View_FEMA_housing_data.yxwz
Action, Append Fields, Comment, Formula, Input Data, Join, Join Multiple, Layout, Map, Map Input, Overlay, Render, Report Map, Report Text, Select, Sort, Tab, Table, Text Input, Tool Container
Closed06 Calculate_a_mortgage_payment.yxwz
Action, Browse, Comment, Drop Down, Filter, Formula, Group, Join, Layout, Numeric Up Down, Render, Report Text, Select, Tab, Table, Text Input, Tool Container, Transpose
Closed06 Identify_tools_and_macros_used_in_a_workflow.yxmd
Browse, Comment, Directory, Tool Container
Closed07 Find_closest_customers_to_a_store.yxwz
Action, Browse, Comment, Create Points, Find Nearest, Input Data, Join, Layout, Map, Map Input, Render, Report Text, Tab, Table, Tool Container
Closed08 Optimize_location_by_minimizing_distance.yxmd
Browse, Comment, Input Data, Tool Container
Closed08 Using_a_tree_with_a_custom_file_database.yxwz
Action, Browse, Comment, Error Message, Filter, Input Data, Tab, Tool Container, Tree
Closed09 Optimize_location_with_a_gravity_model.yxmd
Browse, Comment, Input Data, Tool Container
Closed09 Using_a_tree_file_system.yxwz
Action, Browse, Comment, Error Message, Input Data, Tab, Tool Container, Tree
Closed10 Merge_to_a_master_file_with_fuzzy_matching.yxmd
Browse, Comment, Filter, Formula, Input Data, Join, Select, Sort, Summarize, Tool Container, Union, Unique
Closed10 Using_a_tree_with_custom_XML.yxwz
Action, Browse, Comment, Error Message, Filter, Input Data, Tab, Tool Container, Tree
Closed12 Download_data_from_the_internet.yxwz
Action, Charting, Comment, Date, Download, Drop Down, Error Message, Filter, Formula, Image, Join Multiple, Label, Layout, Link, Record ID, Render, Select, Summarize, Tab, Text Input, Text To Columns, Tool Container
Closed13 Convert_metrics_and_publish_online.yxwz
Action, Browse, Comment, Condition, Detour, Detour End, Drop Down, Dynamic Replace, Filter, Formula, Join, Label, Numeric Up Down, Radio Button, Render, Report Text, Tab, Text Input, Tool Container
Closed14 Find a file in a directory.yxwz
Action, Comment, Condition, Directory, Error Message, File Browse, Filter, Folder Browse, Formula, Image, Join Multiple, Label, Layout, List Box, RegEx, Render, Report Text, Select, Tab, Table, Text Input, Tool Container, Union
ClosedBatchMacro_FileFinder.yxmc
Action, Append Fields, Comment, Control Parameter, File Browse, Filter, Input Data, Macro Output, Select, Summarize, Tab, Text Input, Tool Container
ClosedBatchMacro_IndividualToolCount.yxmc
Action, Append Fields, Browse, Comment, Control Parameter, Filter, Formula, Input Data, Join, Macro Output, RegEx, Select, Summarize, Tab, Text Input, Tool Container, Union
ClosedIterative_Supply_and_Demand.yxmc
Browse, Comment, Filter, Formula, Join, Label, Macro Input, Macro Output, Sample, Select, Sort, Tab, Tool Container, Union
ClosedLocOpt_GenerateReport.yxmc
Action, Append Fields, Browse, Charting, Check Box, Comment, Condition, Cross Tab, Filter, Formula, Group, Join, Macro Input, Macro Output, Report Map, Report Text, Select, Sort, Summarize, Tab, Table, Text Input, Tool Container, Union, Unique
ClosedLocOpt_GravityCreateDemandSurface.yxmc
Action, Append Fields, Check Box, Comment, Condition, Detour, Detour End, Filter, Formula, Macro Input, Macro Output, Numeric Up Down, Select, Summarize, Tab, Text Input, Tool Container, Union
ClosedLocOpt_GravityModel.yxmc
Action, Check Box, Comment, Formula, Join, Join Multiple, Macro Input, Macro Output, Numeric Up Down, Record ID, Select, Tab, Tool Container, Union
ClosedLocOpt_GravityOptimizer.yxmc
Action, Check Box, Comment, Formula, Join, Macro Input, Macro Output, Numeric Up Down, Select, Summarize, Tab, Tool Container
ClosedLocOpt_MinDistanceOptimizer.yxmc
Comment, Find Nearest, Formula, Join, Macro Input, Macro Output, Select, Tab, Tool Container
ClosedLocOpt_MinimizeDistance.yxmc
Action, Browse, Comment, Drop Down, Find Nearest, Formula, Join, Macro Input, Macro Output, Numeric Up Down, Record ID, Report Text, Select, Tab, Table, Tool Container, Union
ClosedLocOpt_RemoveNullFields.yxmc
Action, Comment, Condition, Detour, Detour End, Dynamic Rename, Dynamic Select, Formula, List Box, Macro Input, Macro Output, Radio Button, Select, Summarize, Tab, Tool Container, Transpose

Alteryx.com | Community | Customer Support | Documentation Feedback

©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.