C:\Users\ELLEN~1.WIE\AppData\Local\Temp\Engine_8356_4848054007f14408aacc7b245ae7876b_\Engine_14008_4a8e62df1bb748ea9454aa266af03d47_.yxdb
Single
Map
C:\Users\ELLEN~1.WIE\AppData\Local\Temp\Engine_8356_4848054007f14408aacc7b245ae7876b_\Engine_14008_b19670dd400e452ab3fa3895f6ddd606_.yxdb
Single
Profile
Combine letters and alphabetize
CONCAT
ParseSimple
1_Matched
split to rows
Combo ID - Ascending
CONCAT - Ascending
Match state combos to words
C:\Users\ELLEN~1.WIE\AppData\Local\Temp\Engine_8356_4848054007f14408aacc7b245ae7876b_\Engine_14008_1b1a5c71c9ee46ed90d95c6e633f7c4e_.yxdb
Single
Profile
C:\Users\ellen.wiegand\OneDrive - alteryx.com\Documents\weekly challenges\265\states.yxdb
states.yxdb
C:\Users\ellen.wiegand\OneDrive - alteryx.com\Documents\weekly challenges\265\8letterwords.yxdb
8letterwords.yxdb
Heatmap
Warn
C:\Users\ELLEN~1.WIE\AppData\Local\Temp\Engine_8356_4848054007f14408aacc7b245ae7876b_\Engine_14008_080d268de33149029233d6c01afd8528_.yxdb
Single
Map
C:\Users\ELLEN~1.WIE\AppData\Local\Temp\Engine_8356_4848054007f14408aacc7b245ae7876b_\Engine_14008_5dda3855a85f4c989ad51922dbdb73b4_.xml
8
6
1
Latest:CloudMade
#fdfeff
False
Miles
10
0.5
IncomingConnection
#1
Base Layers - Points
Placeholder
Base Layers - Lines
Placeholder
Polygons
#1
#1
Base Layers - Polygons
Placeholder
High
Polygons
1
1
Above Average
Polygons
1
2
Average
Polygons
1
3
Below Average
Polygons
1
4
Low
Polygons
1
5
Count - Descending
Prep words, alphabetize string
RecordID
100
Int32
6
0
Custom
Word
ParseSimple
Word_Matched
RecordID - Ascending
Word - Ascending
Construct possible combinations
[1] = [3]
Custom
Eliminate Duplicates
Eliminate Duplicates
[1]= [3] OR [1]=[2] OR [1]=[4] OR [2]=[3] OR [2]=[4] OR [3]=[4]
Custom
Eliminate duplicates 2
Eliminate duplicates 2
Combo ID
1
Int32
6
0
Add record IDs for combinations
Match Bordering States
match states
SPATIAL_OBJ Where Target Touches Universe SPATIAL_OBJ
C:\Users\ELLEN~1.WIE\AppData\Local\Temp\Engine_8356_4848054007f14408aacc7b245ae7876b_\Engine_14008_404fd9cef91441ab8686fd3336e16164_.yxdb
Single
Map
RecordID
1
Int32
6
0
!Contains([STATE_CD],"DC")
OR
!Contains([STATE_CD],"AK")
OR
!Contains([STATE_CD],"HI")
Custom
Filter DC, AK, HI
Filter DC, AK, HI
Horizontal
challenge_265_ENWiegand_solution