Sample Workflows

Version:
2019.3
Last modified: September 26, 2019

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.

Learn one tool at a time

Workflow Tools
Action.yxwz Action, AlteryxSelect, Browse, Check Box, Comment, DbFileInput, Detour, File Browse, Filter, Formula, Label, Link, List Box, Map, Map Input, Numeric Up Down, Radio Button, Sample, Sort, Tab, Text Box, Text Input, Tool Container, Trade Area
Append.yxmd Append Fields, Comment, DbFileInput
Auto_Field.yxmd Auto Field, Comment, DbFileInput
Base64_Encoder.yxmd Base64 Encoder, Comment, Text Input
Blob_Convert.yxmd AlteryxSelect, Base64 Encoder, Blob Convert, Blob Input, Browse, Comment, Directory, Text Input, Tool Container
Blob_Input.yxmd AlteryxSelect, Blob Input, Comment, Directory
Blob_Output.yxmd AlteryxSelect, Blob Input, Blob Output, Comment, Directory, Tool Container
Block_Until_Done.yxmd Block Until Done, Comment, Message, Text Input
Browse.yxmd Browse, Comment, DbFileInput
Check_Box.yxwz Action, Browse, Check Box, Comment, Group, Label, Radio Button, Tab, Text Input, Tool Container
Comment.yxmd Comment
Condition.yxwz Action, Browse, Comment, Condition, Formula, Label, Radio Button, Tab, Text Input
Count_Records.yxmd Comment, Count Records, DbFileInput
Cross_Tab.yxmd Comment, Cross Tab, DbFileInput, Text Input, Transpose
Data_Cleansing.yxmd Comment, Data Cleansing, Text Input
Date.yxwz Action, Browse, Comment, Date, Filter, Generate Rows, Tab
DateTime.yxmd AlteryxSelect, Comment, DateTime, Text Input
Directory.yxmd Comment, Directory
Distance.yxmd Comment, Distance, Text Input, Tool Container
Drop_Down.yxwz Action, Browse, Comment, DbFileInput, Drop Down, Dynamic Select, File Browse, Label, Link, Radio Button, Tab, Tool Container
Dynamic_Input.yxmd Browse, Comment, DbFileInput, Directory, Dynamic Input, Map Input
Dynamic_Rename.yxmd Comment, Dynamic Rename, Text Input
Dynamic_Replace.yxmd Comment, Dynamic Replace, Text Input
Dynamic_Select.yxmd Comment, Dynamic Select, Text Input
Error_Message.yxwz Browse, Check Box, Comment, Error Message, Tab, Text Input, Tool Container
Explorer Box.yxmd Comment, Explorer Box
Field_Info.yxmd Comment, DbFileInput, Field Info
Field_Summary.yxmd Browse, Comment, DbFileInput
File_Browse.yxwz Action, Browse, Comment, Condition, DbFileInput, Error Message, File Browse, Label, Link, Output Data, Radio Button, Render, Tab, Table, Tool Container
Filter.yxmd Comment, Filter, Formula, Generate Rows, Join Multiple, Text Input, Tool Container
Find_Replace.yxmd Comment, Find Replace, Text Input
Formula.yxmd Comment, DbFileInput, Formula
Fuzzy_Match.yxmd Comment, Explorer Box, Find Replace, Fuzzy Match, Make Group, Summarize, Text Input
Generate_Rows.yxmd Comment, Generate Rows, Text Input
Image.yxmd Browse, Comment, Directory, Image, Text Input
Imputation.yxmd Comment, Imputation, Text Input
Input_Data.yxmd Comment, DbFileInput
JSON_Parse.yxmd Comment, JSON Parse, Text Input
Join.yxmd Comment, Join, Text Input, Union
Join_Multiple.yxmd Comment, Join, Join Multiple, Text Input, Union
List_Box.yxwz Action, AlteryxSelect, Browse, Comment, DbFileInput, Dynamic Select, File Browse, Label, Link, List Box, Radio Button, Tab, Tool Container
Make_Group.yxmd Comment, Find Replace, Fuzzy Match, Make Group, Summarize, Text Input
Map.yxwz Action, Browse, Comment, File Browse, Label, Map, Map Input, Radio Button, Tab, Tool Container
Map_Input.yxmd Browse, Comment, Map Input
Map_Legend_
Splitter_Builder.yxmd
Browse, Comment, DbFileInput, Formula, Map Legend Builder, Map Legend Builder, Map Legend Splitter, Map Legend Splitter, Report Map
Message.yxmd Browse, Comment, Message, Summarize, Text Input
Multi-Field_Binning.yxmd Comment, Multi-Field Binning, Text Input
Multi-Field_Formula.yxmd Comment, DbFileInput, Multi-Field Formula
Multi-Row_Formula.yxmd Comment, Cross Tab, Multi-Row Formula, Text Input
Numeric_Up_Down.yxwz Browse, Comment, Filter, Generate Rows, Numeric Up Down, Tab
Output_Data.yxmd Comment, Output Data, Text Input
Pearson_Correlation.yxmd Comment, Formula, Pearson Correlation, Spearman Correlation, Text Input
Radio_Button.yxwz Action, Browse, Comment, Label, Radio Button, Tab, Text Input
Random % Sample.yxmd Comment, DbFileInput, Random % Sample, Sample
Record_ID.yxmd Comment, Record ID, Text Input
RegEx.yxmd Comment, DbFileInput, RegEx, Tool Container
Render.yxmd Comment, DbFileInput, Render, Report Footer, Report Footer, Report Header, Report Header, Report Text
Report_Footer.yxmd Browse, Comment, Join Multiple, Layout, Render, Report Footer, Report Text
Report_Header.yxmd Browse, Comment, Join Multiple, Layout, Render, Report Header, Report Text
Report_Map.yxmd AlteryxSelect, Browse, Comment, DbFileInput, Report Map, Text Input
Report_Text.yxmd Browse, Comment, Report Text, Text Input
Running_Total.yxmd Comment, DbFileInput, Running Total
Sample.yxmd Comment, DbFileInput, Sample
Select.yxmd AlteryxSelect, Comment, DbFileInput
Select_Records.yxmd Comment, DbFileInput, Select Records
Sort.yxmd Comment, Sort, Text Input
Spearman_Correlation.yxmd Comment, Formula, Pearson Correlation, Spearman Correlation, Text Input
Summarize.yxmd Comment, DbFileInput, Summarize
Table.yxmd Browse, Comment, Cross Tab, DbFileInput, Table
Test.yxmd Comment, DbFileInput, Test
Text_Box.yxwz Action, Browse, Comment, Label, Radio Button, Tab, Text Box, Text Input, Text To Columns, Tool Container
Text_Input.yxmd Comment, Text Input
Text_To_Columns.yxmd Comment, DbFileInput, Text To Columns
Throttle.yxmd Comment, Text Input, Throttle
Tile.yxmd Comment, DbFileInput, Tile
Tool Container.yxmd Browse, Comment, Field Info, Message, Text Input, Tool Container
Transpose.yxmd Comment, Cross Tab, Text Input, Transpose
Tree.yxwz Action, Browse, Comment, Condition, DbFileInput, Error Message, Filter, Join, Radio Button, Tab, Text Input, Text To Columns, Tool Container, Tree
Union.yxmd Comment, Join, Text Input, Union
Unique.yxmd Comment, DbFileInput, Unique
XML_Parse.yxmd Comment, DbFileInput, Sort, XML Parse

Clean and prepare data

Workflow Tools
Normalize_a_string_field.yxmd Browse, Comment, DbFileInput, Formula, RegEx, Text To Columns, Tool Container
Convert_data_types_with_Auto-Field.yxmd AlteryxSelect, Auto Field, Browse, Comment, DbFileInput, Field Info, Tool Container
Normalize_phone_numbers.yxmd AlteryxSelect, Browse, Comment, DbFileInput, Filter, Formula, RegEx, Tool Container
Measure_the_quality_of_data.yxmd Append Fields, Browse, Comment, DbFileInput, Formula, Message, Sort, Summarize, Tool Container, Transpose
Normalize_an_
unstructured_.txt_file.yxmd
AlteryxSelect, Browse, Comment, Cross Tab, DbFileInput, Filter, Formula, Join, Multi-Row Formula, RegEx, Summarize, Text To Columns, Tool Container, Transpose
Append_a_leading_character.yxmd Browse, Comment, DbFileInput, Formula, Tool Container
Normalize_an_
unstructured_.xml_file.yxmd
AlteryxSelect, Browse, Comment, DbFileInput, Tool Container, XML Parse
Infer_ZIP_codes_from_
latitude_and_longitude.yxmd
Browse, Comment, DbFileInput, Dynamic Input, Tool Container
Smooth_spatial_objects_
on_a_map.yxmd
Buffer, Comment, Create Points, DbFileInput, Generalize, Render, Report Map, Report Text, Smooth, Text Input, Tool Container, Trade Area
Create_an_.xml_file.yxmd Browse, Comment, Formula, Join, Output Data, Summarize, Text Input, Tool Container, Union

Describe what is happening

Workflow Tools
Create_service_boundaries.yxmd AlteryxSelect, Browse, Comment, Create Points, DbFileInput, Distance, Formula, Join, Spatial Match, Summarize, Tool Container, Trade Area, Union
Join_data_from_two_sources.yxmd Browse, Comment, DbFileInput, Formula, Join, Summarize, Tool Container
Join_data_from_
multiple_sources.yxmd
Browse, Comment, DbFileInput, Join Multiple, Tool Container
Learn_frequently-used_tools.yxmd AlteryxSelect, Browse, Comment, DbFileInput, Filter, Formula, Join, Record ID, Sample, Sort, Summarize, Text Input, Tool Container, Union, Unique
Group_sales_by_county.yxmd AlteryxSelect, Browse, Comment, DbFileInput, Formula, Summarize, Tool Container
Join_rows_with_Union.yxmd Browse, Comment, DbFileInput, Record ID, Tool Container, Union
Map_trade_areas_1.yxmd Comment, Create Points, DbFileInput, Filter, Find Nearest, Formula, Join, Poly-Build, Record ID, Render, Report Map, Sort, Summarize, Tile, Tool Container
Find_all_customers_within_
30_miles_of_a_store.yxmd
AlteryxSelect, Browse, Comment, Create Points, DbFileInput, Distance, Join, Sort, Spatial Match, Summarize, Tool Container, Trade Area
Map_trade_areas_2.yxmd AlteryxSelect, Comment, Create Points, DbFileInput, Render, Report Map, Report Text, Tool Container, Trade Area
Download_and_parse_web_data.yxmd AlteryxSelect, Auto Field, Browse, Comment, Create Points, Date Time Now, DateTime, Download, Dynamic Rename, Formula, Join, Layout, Message, Multi-Field Formula, Render, Report Map, Report Text, Sample, Sort, Table, Text Input, Text To Columns, Tool Container
Overlay_a_zip_code_map_1.yxmd Browse, Comment, DbFileInput, Report Map, Spatial Match, Tool Container
Create_a_report_with_a_
chart_and_a_table.yxmd
Charting, Comment, DbFileInput, Image, Join Multiple, Layout, Render, Report Text, Sort, Table, Tool Container
Overlay_a_zip_code_map_2.yxmd Browse, Comment, DbFileInput, Formula, Join, Spatial Info, Summarize, Tool Container
Create_summary_tables
_for_a_report.yxmd
AlteryxSelect, Comment, Cross Tab, DbFileInput, Image, Join Multiple, Layout, Render, Report Text, Summarize, Table, Tool Container
Measure_the_overlap_
of_ad_coverage.yxmd
AlteryxSelect, Browse, Comment, Create Points, DbFileInput, Formula, Spatial Info, Spatial Match, Spatial Process, Tool Container, Trade Area
Make_a_contingency_table.yxmd AlteryxSelect, Browse, Comment, Cross Tab, DbFileInput, Summarize, Tool Container
Read_a_.flat_file.yxmd Browse, Comment, DbFileInput, Filter, Tool Container
Create_tables_from_
unicode_data.yxmd
Charting, Comment, Image, Join, Join Multiple, Layout, Render, Report Text, Table, Text Input, Tool Container
Create_a_report_layout.yxmd Charting, Comment, DbFileInput, Image, Join Multiple, Layout, Render, Report Footer, Report Map, Report Text, Summarize, Table, Tool Container

Diagnose why it is happening

Workflow Tools
Append_a_calculated_field.yxmd Append Fields, Browse, Comment, DbFileInput, Formula, Summarize, Tool Container, Unique
Apply_a_formula_to_
multiple_fields.yxmd
AlteryxSelect, Browse, Comment, DbFileInput, Multi-Field Formula, Tool Container
Find_the_closest_stores_
to_customers.yxmd
AlteryxSelect, Browse, Comment, Create Points, DbFileInput, Find Nearest, Summarize, Tool Container
 Create_a_report_with_
a_thematic_map.yxmd
Append Fields, Comment, Create Points, DbFileInput, Formula, 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
Calculate_a_trend_and_
sort_data.yxmd
AlteryxSelect, Browse, Comment, DbFileInput, Filter, Formula, Sample, Sort, Tool Container

Use scripting and automation tools

Workflow Tools
StrongADD_FuzzyFL.yxmc AlteryxSelect, Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Sort, Tab, Tool Container, Union, Unique
Convert_file_formats.yxwz Action, Comment, DbFileInput, Error Message, File Browse, Output Data, Tab, Tool Container
StrongADD_FuzzyLF.yxmc AlteryxSelect, Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Sort, Tab, Tool Container, Union, Unique
Assign_supply_to_demand.yxmd AlteryxSelect, Append Fields, Browse, Comment, DbFileInput, Distance, Record ID, Sort, Summarize, Test, Tool Container
Clean_and_parse_
phone_numbers.yxwz
Action, AlteryxSelect, Comment, Condition, DbFileInput, Error Message, File Browse, Filter, Formula, List Box, Output Data, Radio Button, RegEx, Tab, Tool Container, Union
StrongFL_FuzzyADD.yxmc AlteryxSelect, Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Sort, Tab, Tool Container, Union, Unique
Define_trade_areas.yxwz Action, Comment, Create Points, DbFileInput, File Browse, Filter, Find Nearest, Formula, Join, Label, Numeric Up Down, Poly-Build, Record ID, Render, Report Map, Sort, Summarize, Tab, Tile, Tool Container
Map_customers_by_store.yxmd Comment, Create Points, DbFileInput, Find Nearest, Join, Pie Wedge Trade Area, Record ID, Render, Report Map, Report Text, Tool Container
StrongADD_FuzzyFL_Char.yxmc AlteryxSelect, Comment, Filter, Formula, Fuzzy Match, Join, Macro Input, Macro Output, Sort, Tab, Tool Container, Union, Unique
Create_a_heat_map_
for_purchase_data.yxmd
Comment, Create Points, DbFileInput, Heat Map, Render, Report Map, Report Text, Tool Container
View_FEMA_housing_data.yxwz Action, AlteryxSelect, Append Fields, Comment, DbFileInput, Formula, Join, Join Multiple, Layout, Map, Map Input, Overlay, Render, Report Map, Report Text, Sort, Tab, Table, Text Input, Tool Container
Calculate_a_mortgage_
payment.yxwz
Action, AlteryxSelect, Browse, Comment, Drop Down, Filter, Formula, Group, Join, Layout, Numeric Up Down, Render, Report Text, Tab, Table, Text Input, Tool Container, Transpose
Identify_tools_and_macros_
used_in_a_workflow.yxmd
Browse, Comment, Directory, Tool Container
Find_closest_customers_
to_a_store.yxwz
Action, Browse, Comment, Create Points, DbFileInput, Find Nearest, Join, Layout, Map, Map Input, Render, Report Text, Tab, Table, Tool Container
Optimize_location_by_
minimizing_distance.yxmd
Browse, Comment, DbFileInput, Tool Container
Using_a_tree_with_a_
custom_file_database.yxwz
Action, Browse, Comment, DbFileInput, Error Message, Filter, Tab, Tool Container, Tree
Optimize_location_with_a_
gravity_model.yxmd
Browse, Comment, DbFileInput, Tool Container
Using_a_tree_file_system.yxwz Action, Browse, Comment, DbFileInput, Error Message, Tab, Tool Container, Tree
Merge_to_a_master_file_
with_fuzzy_matching.yxmd
AlteryxSelect, Browse, Comment, DbFileInput, Filter, Formula, Join, Sort, Summarize, Tool Container, Union, Unique
Using_a_tree_with_
custom_XML.yxwz
Action, Browse, Comment, DbFileInput, Error Message, Filter, Tab, Tool Container, Tree
Download_data_from_
the_internet.yxwz
Action, AlteryxSelect, Charting, Comment, Date, Download, Drop Down, Error Message, Filter, Formula, Image, Join Multiple, Label, Layout, Link, Record ID, Render, Summarize, Tab, Text Input, Text To Columns, Tool Container
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
Find a file in a directory.yxwz Action, AlteryxSelect, Comment, Condition, Directory, Error Message, File Browse, Filter, Folder Browse, Formula, Image, Join Multiple, Label, Layout, List Box, RegEx, Render, Report Text, Tab, Table, Text Input, Tool Container, Union
BatchMacro_FileFinder.yxmc Action, AlteryxSelect, Append Fields, Comment, Control Parameter, DbFileInput, File Browse, Filter, Macro Output, Summarize, Tab, Text Input, Tool Container
BatchMacro_
IndividualToolCount.yxmc
Action, AlteryxSelect, Append Fields, Browse, Comment, Control Parameter, DbFileInput, Filter, Formula, Join, Macro Output, RegEx, Summarize, Tab, Text Input, Tool Container, Union
Iterative_Supply_and_Demand.yxmc AlteryxSelect, Browse, Comment, Filter, Formula, Join, Label, Macro Input, Macro Output, Sample, Sort, Tab, Tool Container, Union
LocOpt_GenerateReport.yxmc Action, AlteryxSelect, Append Fields, Browse, Charting, Check Box, Comment, Condition, Cross Tab, Filter, Formula, Group, Join, Macro Input, Macro Output, Report Map, Report Text, Sort, Summarize, Tab, Table, Text Input, Tool Container, Union, Unique
LocOpt_GravityCreate
DemandSurface.yxmc
Action, AlteryxSelect, Append Fields, Check Box, Comment, Condition, Detour, Detour End, Filter, Formula, Macro Input, Macro Output, Numeric Up Down, Summarize, Tab, Text Input, Tool Container, Union
LocOpt_GravityModel.yxmc Action, AlteryxSelect, Check Box, Comment, Formula, Join, Join Multiple, Macro Input, Macro Output, Numeric Up Down, Record ID, Tab, Tool Container, Union
LocOpt_GravityOptimizer.yxmc Action, AlteryxSelect, Check Box, Comment, Formula, Join, Macro Input, Macro Output, Numeric Up Down, Summarize, Tab, Tool Container
LocOpt_MinDistanceOptimizer.yxmc AlteryxSelect, Comment, Find Nearest, Formula, Join, Macro Input, Macro Output, Tab, Tool Container
LocOpt_MinimizeDistance.yxmc Action, AlteryxSelect, Browse, Comment, Drop Down, Find Nearest, Formula, Join, Macro Input, Macro Output, Numeric Up Down, Record ID, Report Text, Tab, Table, Tool Container, Union
LocOpt_RemoveNullFields.yxmc Action, AlteryxSelect, Comment, Condition, Detour, Detour End, Dynamic Rename, Dynamic Select, Formula, List Box, Macro Input, Macro Output, Radio Button, Summarize, Tab, Tool Container, Transpose
Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.