Input Output iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg== Weekly Challenge #15 1 467764.31807845 2 520950.356459252 3 418529.43408498 4 471483.324599005 5 613089.857981943 6 338432.74381217 7 654162.976293154 8 465070.542812818 9 385441.880195139 10 385761.522224907 F:\AlteryxServer\Workspace\Engine\Engine_50776_b30e0de548184227a44c1618127e29ab_\Engine_13056_710d7d32940f4fbab55cc0b74d0de406_.yxdb Single Profile A 26 Houston TX -95.562207 29.839187 B 4 Birmingham AL -86.625591 33.410321 C 25 Seattle WA -122.291399 47.603993 D 3 Detroit MI -83.255088 42.412144 E 5 Nashville TN -86.729174 36.135464 F 2 Chicago IL -87.597287 41.734 G 24 Lansing IA -91.228717 43.361018 H 1 Fayetteville NC -78.907738 35.024302 I 23 Miami FL -80.31047 25.792304 J 22 Tampa FL -82.539427 27.886595 K 21 Charleston SC -80.063175 32.931254 L 6 Los Angeles CA -118.386826 33.945722 M 20 Sacramento CA -121.40379 38.568865 N 7 Tucson AZ -110.845502 32.311728 O 8 Dallas TX -96.770293 32.84673 P 19 Austin TX -97.713678 30.19727 Q 9 Tulsa OK -95.861086 36.177745 R 16 New York NY -74.002527 40.734408 S 10 Baltimore MD -76.467296 39.3277 T 15 Portland OR -122.889658 45.563461 U 11 Philadelphia PA -75.171584 39.955317 V 12 Boston MA -71.066428 42.315352 W 13 Helena MT -112.00339 46.593143 X 14 Denver CO -104.943955 39.709101 Y 18 Milwaukee WI -87.925026 42.96156 Z 17 Las Vegas NV -115.242869 36.177034 F:\AlteryxServer\Workspace\Engine\Engine_50776_b30e0de548184227a44c1618127e29ab_\Engine_13056_11a1f1f0888e4b5ea8b8d9b8759e8abb_.yxdb Single Table F:\AlteryxServer\Workspace\Engine\Engine_50776_b30e0de548184227a44c1618127e29ab_\Engine_13056_41fe2f5ec2e449a89d6cdfa62dd99203_.yxdb Single Table A 1 47 47 A 2 29 29 A 3 50 50 A 4 12 12 A 5 19 19 A 6 72 0 A 7 71 13 A 8 2 0 A 10 40 40 B 2 46 46 B 3 36 36 B 4 7 7 B 5 48 48 B 6 71 71 B 7 19 19 B 10 4 4 C 1 34 34 C 2 52 52 C 3 66 66 C 4 17 17 C 6 3 2 C 7 57 57 C 8 77 64 C 10 13 13 D 2 1 1 D 3 76 76 D 4 46 46 D 6 21 21 D 7 40 40 D 10 41 41 E 1 44 44 E 2 14 14 E 5 75 75 E 6 32 32 E 7 14 14 E 8 76 76 E 10 42 42 F 1 71 71 F 2 28 28 F 3 46 46 F 4 54 54 F 5 9 9 F 6 52 52 F 7 43 43 F 8 33 33 F 9 59 59 F 10 16 16 G 1 60 60 G 2 2 2 G 3 51 51 G 4 66 66 G 5 47 47 G 6 28 28 G 7 66 66 G 9 30 0 G 10 55 55 H 1 11 11 H 2 69 69 H 3 5 5 H 4 41 41 H 5 54 54 H 7 28 28 H 8 57 57 H 9 17 17 H 10 36 36 I 2 6 6 I 4 73 73 I 5 43 43 I 6 3 3 I 7 70 70 I 8 70 70 I 9 16 0 I 10 17 17 J 1 71 71 J 2 35 35 J 4 5 5 J 5 79 79 J 6 9 9 J 7 38 38 J 9 55 21 J 10 72 72 K 1 44 44 K 2 13 13 K 3 63 63 K 4 73 73 K 6 62 62 K 7 61 61 K 8 20 20 K 10 25 25 L 1 26 26 L 3 10 10 L 4 35 35 L 5 62 62 L 6 16 16 L 7 73 73 L 8 35 35 L 9 78 78 L 10 33 33 M 2 12 12 M 3 23 23 M 4 55 55 M 5 46 46 M 6 9 9 M 7 4 4 M 8 8 8 M 9 76 76 M 10 60 60 N 2 9 9 N 4 29 29 N 5 12 12 N 6 4 4 N 7 36 36 N 8 3 3 N 10 8 8 O 1 15 15 O 2 35 35 O 5 30 30 O 6 43 43 O 8 78 78 O 9 48 48 O 10 64 64 P 2 60 60 P 3 33 33 P 4 5 5 P 5 9 9 P 6 27 27 P 7 62 62 P 8 71 71 P 9 30 30 P 10 50 50 Q 2 22 22 Q 3 32 32 Q 4 11 11 Q 5 4 4 Q 6 46 46 Q 7 69 69 Q 8 46 46 Q 9 12 12 Q 10 53 53 R 2 76 76 R 3 15 15 R 4 13 13 R 5 69 69 R 6 41 41 R 7 49 49 R 8 50 50 R 10 9 9 S 1 23 23 S 2 9 9 S 4 27 27 S 5 31 31 S 6 31 31 S 7 17 17 S 8 69 69 S 9 53 53 S 10 21 21 T 1 19 19 T 2 66 66 T 3 76 76 T 4 56 56 T 5 78 78 T 6 53 53 T 7 62 62 T 8 2 2 T 9 12 12 U 1 71 71 U 2 54 54 U 4 3 3 U 5 54 54 U 6 3 3 U 7 48 48 U 8 6 6 V 1 65 65 V 2 30 30 V 3 4 4 V 4 12 12 V 5 50 50 V 7 37 37 V 8 10 10 V 9 76 76 W 1 76 76 W 2 68 68 W 3 10 10 W 4 48 48 W 5 65 65 W 7 60 60 W 8 15 15 W 9 31 31 X 1 8 8 X 2 49 49 X 3 57 57 X 4 23 23 X 5 25 25 X 7 39 39 X 8 45 45 X 9 68 68 Y 1 6 6 Y 2 47 47 Y 4 1 1 Y 5 26 26 Y 6 64 64 Y 7 33 33 Y 8 41 41 Y 9 33 33 Y 10 7 7 Z 1 60 60 Z 2 25 25 Z 3 39 39 Z 4 45 45 Z 5 75 75 Z 6 18 18 Z 7 18 18 Z 8 25 25 Z 9 2 2 Z 10 10 10 Main Huntsville AL 34.737177 -86.603266 Second El Paso TX 31.767002 -106.492058 Third Colorado Springs CO 38.825775 -104.831478 F:\AlteryxServer\Workspace\Engine\Engine_50776_b30e0de548184227a44c1618127e29ab_\Engine_13056_ad129140f57d44c19844c1261cdf2d1c_.yxdb Single Table A 26 Houston TX -95.562207 29.839187 B 4 Birmingham AL -86.625591 33.410321 C 25 Seattle WA -122.291399 47.603993 D 3 Detroit MI -83.255088 42.412144 E 5 Nashville TN -86.729174 36.135464 F 2 Chicago IL -87.597287 41.734 G 24 Lansing IA -91.228717 43.361018 H 1 Fayetteville NC -78.907738 35.024302 I 23 Miami FL -80.31047 25.792304 J 22 Tampa FL -82.539427 27.886595 K 21 Charleston SC -80.063175 32.931254 L 6 Los Angeles CA -118.386826 33.945722 M 20 Sacramento CA -121.40379 38.568865 N 7 Tucson AZ -110.845502 32.311728 O 8 Dallas TX -96.770293 32.84673 P 19 Austin TX -97.713678 30.19727 Q 9 Tulsa OK -95.861086 36.177745 R 16 New York NY -74.002527 40.734408 S 10 Baltimore MD -76.467296 39.3277 T 15 Portland OR -122.889658 45.563461 U 11 Philadelphia PA -75.171584 39.955317 V 12 Boston MA -71.066428 42.315352 W 13 Helena MT -112.00339 46.593143 X 14 Denver CO -104.943955 39.709101 Y 18 Milwaukee WI -87.925026 42.96156 Z 17 Las Vegas NV -115.242869 36.177034 A 1 47 47 A 2 29 29 A 3 50 50 A 4 12 12 A 5 19 19 A 6 72 0 A 7 71 13 A 8 2 0 A 10 40 40 B 2 46 46 B 3 36 36 B 4 7 7 B 5 48 48 B 6 71 71 B 7 19 19 B 10 4 4 C 1 34 34 C 2 52 52 C 3 66 66 C 4 17 17 C 6 3 2 C 7 57 57 C 8 77 64 C 10 13 13 D 2 1 1 D 3 76 76 D 4 46 46 D 6 21 21 D 7 40 40 D 10 41 41 E 1 44 44 E 2 14 14 E 5 75 75 E 6 32 32 E 7 14 14 E 8 76 76 E 10 42 42 F 1 71 71 F 2 28 28 F 3 46 46 F 4 54 54 F 5 9 9 F 6 52 52 F 7 43 43 F 8 33 33 F 9 59 59 F 10 16 16 G 1 60 60 G 2 2 2 G 3 51 51 G 4 66 66 G 5 47 47 G 6 28 28 G 7 66 66 G 9 30 0 G 10 55 55 H 1 11 11 H 2 69 69 H 3 5 5 H 4 41 41 H 5 54 54 H 7 28 28 H 8 57 57 H 9 17 17 H 10 36 36 I 2 6 6 I 4 73 73 I 5 43 43 I 6 3 3 I 7 70 70 I 8 70 70 I 9 16 0 I 10 17 17 J 1 71 71 J 2 35 35 J 4 5 5 J 5 79 79 J 6 9 9 J 7 38 38 J 9 55 21 J 10 72 72 K 1 44 44 K 2 13 13 K 3 63 63 K 4 73 73 K 6 62 62 K 7 61 61 K 8 20 20 K 10 25 25 L 1 26 26 L 3 10 10 L 4 35 35 L 5 62 62 L 6 16 16 L 7 73 73 L 8 35 35 L 9 78 78 L 10 33 33 M 2 12 12 M 3 23 23 M 4 55 55 M 5 46 46 M 6 9 9 M 7 4 4 M 8 8 8 M 9 76 76 M 10 60 60 N 2 9 9 N 4 29 29 N 5 12 12 N 6 4 4 N 7 36 36 N 8 3 3 N 10 8 8 O 1 15 15 O 2 35 35 O 5 30 30 O 6 43 43 O 8 78 78 O 9 48 48 O 10 64 64 P 2 60 60 P 3 33 33 P 4 5 5 P 5 9 9 P 6 27 27 P 7 62 62 P 8 71 71 P 9 30 30 P 10 50 50 Q 2 22 22 Q 3 32 32 Q 4 11 11 Q 5 4 4 Q 6 46 46 Q 7 69 69 Q 8 46 46 Q 9 12 12 Q 10 53 53 R 2 76 76 R 3 15 15 R 4 13 13 R 5 69 69 R 6 41 41 R 7 49 49 R 8 50 50 R 10 9 9 S 1 23 23 S 2 9 9 S 4 27 27 S 5 31 31 S 6 31 31 S 7 17 17 S 8 69 69 S 9 53 53 S 10 21 21 T 1 19 19 T 2 66 66 T 3 76 76 T 4 56 56 T 5 78 78 T 6 53 53 T 7 62 62 T 8 2 2 T 9 12 12 U 1 71 71 U 2 54 54 U 4 3 3 U 5 54 54 U 6 3 3 U 7 48 48 U 8 6 6 V 1 65 65 V 2 30 30 V 3 4 4 V 4 12 12 V 5 50 50 V 7 37 37 V 8 10 10 V 9 76 76 W 1 76 76 W 2 68 68 W 3 10 10 W 4 48 48 W 5 65 65 W 7 60 60 W 8 15 15 W 9 31 31 X 1 8 8 X 2 49 49 X 3 57 57 X 4 23 23 X 5 25 25 X 7 39 39 X 8 45 45 X 9 68 68 Y 1 6 6 Y 2 47 47 Y 4 1 1 Y 5 26 26 Y 6 64 64 Y 7 33 33 Y 8 41 41 Y 9 33 33 Y 10 7 7 Z 1 60 60 Z 2 25 25 Z 3 39 39 Z 4 45 45 Z 5 75 75 Z 6 18 18 Z 7 18 18 Z 8 25 25 Z 9 2 2 Z 10 10 10 Main Huntsville AL 34.737177 -86.603266 Second El Paso TX 31.767002 -106.492058 Third Colorado Springs CO 38.825775 -104.831478 Double Double Error Centroid Source_Centroid Latest:TeleAtlas_UK Miles Shortest distance to warehouse by store Store Store Store FindWhole Append [DistanceMiles] = [Min_DistanceMiles] Custom = DistanceMiles True fixed 2020-03-25 07:04:17 0 2020-03-25 07:04:17 2020-03-25 07:04:17 Filter to closest warehouse [DistanceMiles] = [Min_DistanceMiles] Store Store City FindWhole Append Sum miles by Item F:\AlteryxServer\Workspace\Engine\Engine_50776_b30e0de548184227a44c1618127e29ab_\Engine_13056_5129781d0af64b0abafa6fe1ebea6de3_.yxdb Single Profile Horizontal challenge_15_mysolution