Task 1
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_a68bbc2e1c034ae5af2d2eddbbd4b1ee_.yxdb
Single
Map
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #269
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_ec856f3a8f7648b3859351376b17b8fe_.yxdb
Inputs\LSOA pop.csv
28591
,
False
254
False
False
DoubleQuotes
1
LSOA pop.csv
Inputs\Countries.yxdb
Countries.yxdb
Inputs\Districts.yxdb
Districts.yxdb
Inputs\Population.yxdb
Population.yxdb
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_d87cf56614b047b8936dc8044af8aa2a_.yxdb
Single
Map
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_4f12917def564be0804084b22135a9ff_.yxdb
Single
Map
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_dce6bffeb28541f8b9a64359fe603f06_.yxdb
Single
Map
Task 2
Task 3
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_a3b777938eac4029a1c6bd42ccc58f60_.yxdb
Single
Report
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_7da943029a544f89b3a81237c05f9539_.yxdb
Single
Report
Outputs\population weighted.yxdb
population weighted.yxdb
Outputs\unweighted centroids.yxdb
unweighted centroids.yxdb
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_e659adf5935341c194198498732bcd67_.yxdb
Single
Report
Outputs\3b.yxdb
3b.yxdb
Outputs\3c.yxdb
3c.yxdb
Skip
2
Skip 1st 2
FirstRow
Warn
Task 3
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_c2413cb7d61d401790f59a0a09d1b715_.xml
8
6
1
Latest:CloudMade
#fdfeff
False
Miles
10
0.5
IncomingConnection
#1
% Over 65
Base Layers - Points
Placeholder
Base Layers - Lines
Placeholder
Polygons
Percent
#1
Base Layers - Polygons
Placeholder
Polygons
Above 28
#1
1
1
26
to 28
Polygons
1
2
Polygons
1
3
Polygons
1
4
Polygons
1
5
Polygons
1
6
Polygons
1
7
Polygons
1
8
pdf
Map
Continuous
Header
Footer
1
squeeze
warning
Source: Office for National Statistics licensed under the Open Government Licence v.3.0; Contains OS data © Crown copyright and database right 2021
Alteryx, Inc. - info@alteryx.com - <Link www.alteryx.com|www.alteryx.com> - 888 836 4274
True
Proportion of population aged over 65 (for England and Wales)
False
Month dd, yyyy
True
True
False
False
LA Code (2020 boundaries)
Pop Density (per SqMi)
% Over 65
False
True
True
50
True
False
False
False
False
False
False
LA Code (2020 boundaries)
False
True
False
False
False
False
Pop Density (per SqMi)
% Over 65
10
1.0
1.2
1.3
1.4
True
5.50
5.50
False
13.00
14.95
1x
Basic
100%
Basic Table
Warning
All
ByPos
pdf
Layout
Continuous
Footer
1
squeeze
warning
PerRecord
H
Continuous
100%
0
Horizontal Layout
Each Individual Record
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_f8ce8694476747878d89332d8447a39a_.yxdb
Single
Report
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_4ccc1db39e6c4bf39dee257be109a068_.yxdb
Single
Report
Source: Office for National Statistics licensed under the Open Government Licence v.3.0; Contains OS data © Crown copyright and database right 2021
Alteryx, Inc. - info@alteryx.com - <Link www.alteryx.com|www.alteryx.com> - 888 836 4274
True
Task 2
SpatialObj Where Target Within Universe SpatialObj
Miles
Latest
Warning
All
ByName
CentroidX
All Ages
WeightedCentroidX
ctry17nm
CentroidY
All Ages
WeightedCentroidY
ctry17nm
Error
Double
Country Centroids
Population weighted centroids
Latest
Miles
Basic
100%
Basic Table
pdf
Layout
Continuous
1
squeeze
warning
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_ee8dce0eb4a34e2eb01654b2829fdb22_.yxdb
Single
Report
PerRecord
H
Continuous
100%
0
Horizontal Layout
Each Individual Record
Warning
All
ByPos
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_860efb33742b456486cda1982c25d6b2_.xml
8
6
1
Latest:CloudMade
#fdfeff
False
Miles
10
0.5
IncomingConnection
Country Bondaries
IncomingConnection
Country Centroids
IncomingConnection
Population weighted centroids
Points
Country Centroids
Country Centroids
Points
Population weighted centroids
Population weighted centroids
Base Layers - Points
Placeholder
Base Layers - Lines
Placeholder
Polygons
Country Boundaries
Country Bondaries
Base Layers - Polygons
Placeholder
Task 1
C:\Users\NLENSI~1\AppData\Local\Temp\Engine_11724_961301840d75418e8df21364fe3f392b_\Engine_13308_0c0dfad92672456ba46087734f0d40c0_.yxdb
Single
Map
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Vertical
challenge_269_start_file