Inputs
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
The FIFA World Cup is currently taking place in Qatar. Pawel would like to perform analyses on the event.
The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude.
The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.
For this challenge:
1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage.
2. Find the three cities with the most World Cup matches.
Data Source: https://www.kaggle.com/datasets/palecznypawel/worldcup2022-fixture
Weekly Challenge #349
Outputs
C:\ProgramData\Alteryx\Engine\Engine_9944_131daab9a79b4dab893c2d7e8d3b0113_\Engine_9792_b3eda0aefb6b44e3948296ba59956c45_.yxdb
Single
Profile
Al Bayt Stadium
Al Khor City
60000
25.680408
51.496850
Lusail Stadium
Lusail City
80000
25.500000
51.483334
Ahmad Bin Ali Stadium
Al Rayyan
40000
25.285446
51.531040
Al Janoub Stadium
Al Wakrah
40000
25.176816
51.604843
Al Thumama Stadium
Al Thumama
40000
25.236347
51.564963
Education City Stadium
Al Rayyan
40000
25.285446
51.531040
Khalifa International Stadium
Al Rayyan
40000
25.285446
51.531040
Stadium 974
Ras Abu Abboud
40000
25.259596
51.583514
Doha
25.286106
51.534817
2
1
21.11.2022 10:00
Al Thumama Stadium
Senegal vs. Netherlands
Group A
3
1
21.11.2022 13:00
Khalifa International Stadium
England vs. Iran
Group B
1
1
21.11.2022 16:00
Al Bayt Stadium
Qatar vs. Ecuador
Group A
4
1
21.11.2022 19:00
Ahmad Bin Ali Stadium
USA vs. Wales
Group B
8
1
22.11.2022 10:00
Lusail Stadium
Argentina vs. Saudi Arabia
Group C
6
1
22.11.2022 13:00
Education City Stadium
Denmark vs. Tunisia
Group D
7
1
22.11.2022 16:00
Stadium 974
Mexico vs. Poland
Group C
5
1
22.11.2022 19:00
Al Janoub Stadium
France vs. Australia
Group D
12
1
23.11.2022 10:00
Al Bayt Stadium
Morocco vs. Croatia
Group F
11
1
23.11.2022 13:00
Khalifa International Stadium
Germany vs. Japan
Group E
10
1
23.11.2022 16:00
Al Thumama Stadium
Spain vs. Costa Rica
Group E
9
1
23.11.2022 19:00
Ahmad Bin Ali Stadium
Belgium vs. Canada
Group F
13
1
24.11.2022 10:00
Al Janoub Stadium
Switzerland vs. Cameroon
Group G
14
1
24.11.2022 13:00
Education City Stadium
Uruguay vs. Korea Republic
Group H
15
1
24.11.2022 16:00
Stadium 974
Portugal vs. Ghana
Group H
16
1
24.11.2022 19:00
Lusail Stadium
Brazil vs. Serbia
Group G
17
2
25.11.2022 10:00
Ahmad Bin Ali Stadium
Wales vs. Iran
Group B
18
2
25.11.2022 13:00
Al Thumama Stadium
Qatar vs. Senegal
Group A
19
2
25.11.2022 16:00
Khalifa International Stadium
Netherlands vs. Ecuador
Group A
20
2
25.11.2022 19:00
Al Bayt Stadium
England vs. USA
Group B
21
2
26.11.2022 10:00
Al Janoub Stadium
Tunisia vs. Australia
Group D
22
2
26.11.2022 13:00
Education City Stadium
Poland vs. Saudi Arabia
Group C
23
2
26.11.2022 16:00
Stadium 974
France vs. Denmark
Group D
24
2
26.11.2022 19:00
Lusail Stadium
Argentina vs. Mexico
Group C
25
2
27.11.2022 10:00
Ahmad Bin Ali Stadium
Japan vs. Costa Rica
Group E
26
2
27.11.2022 13:00
Al Thumama Stadium
Belgium vs. Morocco
Group F
27
2
27.11.2022 16:00
Khalifa International Stadium
Croatia vs. Canada
Group F
28
2
27.11.2022 19:00
Al Bayt Stadium
Spain vs. Germany
Group E
29
2
28.11.2022 10:00
Al Janoub Stadium
Cameroon vs. Serbia
Group G
30
2
28.11.2022 13:00
Education City Stadium
Korea Republic vs. Ghana
Group H
31
2
28.11.2022 16:00
Stadium 974
Brazil vs. Switzerland
Group G
32
2
28.11.2022 19:00
Lusail Stadium
Portugal vs. Uruguay
Group H
35
3
29.11.2022 15:00
Khalifa International Stadium
Ecuador vs. Senegal
Group A
36
3
29.11.2022 15:00
Al Bayt Stadium
Netherlands vs. Qatar
Group A
33
3
29.11.2022 19:00
Ahmad Bin Ali Stadium
Wales vs. England
Group B
34
3
29.11.2022 19:00
Al Thumama Stadium
Iran vs. USA
Group B
37
3
30.11.2022 15:00
Al Janoub Stadium
Australia vs. Denmark
Group D
38
3
30.11.2022 15:00
Education City Stadium
Tunisia vs. France
Group D
39
3
30.11.2022 19:00
Stadium 974
Poland vs. Argentina
Group C
40
3
30.11.2022 19:00
Lusail Stadium
Saudi Arabia vs. Mexico
Group C
41
3
01.12.2022 15:00
Ahmad Bin Ali Stadium
Croatia vs. Belgium
Group F
42
3
01.12.2022 15:00
Al Thumama Stadium
Canada vs. Morocco
Group F
43
3
01.12.2022 19:00
Khalifa International Stadium
Japan vs. Spain
Group E
44
3
01.12.2022 19:00
Al Bayt Stadium
Costa Rica vs. Germany
Group E
45
3
02.12.2022 15:00
Al Janoub Stadium
Ghana vs. Uruguay
Group H
46
3
02.12.2022 15:00
Education City Stadium
Korea Republic vs. Portugal
Group H
47
3
02.12.2022 19:00
Stadium 974
Serbia vs. Switzerland
Group G
48
3
02.12.2022 19:00
Lusail Stadium
Cameroon vs. Brazil
Group G
49
Round of 16
03.12.2022 15:00
Khalifa International Stadium
1A vs. 2B
Play Off
50
Round of 16
03.12.2022 19:00
Ahmad Bin Ali Stadium
1C vs. 2D
Play Off
52
Round of 16
04.12.2022 15:00
Al Thumama Stadium
1D vs. 2C
Play Off
51
Round of 16
04.12.2022 19:00
Al Bayt Stadium
1B vs. 2A
Play Off
53
Round of 16
05.12.2022 15:00
Al Janoub Stadium
1E vs. 2F
Play Off
54
Round of 16
05.12.2022 19:00
Stadium 974
1G vs. 2H
Play Off
55
Round of 16
06.12.2022 15:00
Education City Stadium
1F vs. 2E
Play Off
56
Round of 16
06.12.2022 19:00
Lusail Stadium
1H vs. 2G
Play Off
58
Quarter Finals
09.12.2022 15:00
Education City Stadium
W53 vs. W54
Play Off
57
Quarter Finals
09.12.2022 19:00
Lusail Stadium
W49 vs. W48
Play Off
60
Quarter Finals
10.12.2022 15:00
Al Thumama Stadium
W55 vs. W56
Play Off
59
Quarter Finals
10.12.2022 19:00
Al Bayt Stadium
W51 vs. W52
Play Off
61
Semi Finals
13.12.2022 19:00
Lusail Stadium
W57 vs. W58
Play Off
62
Semi Finals
14.12.2022 19:00
Al Bayt Stadium
W59 vs. W60
Play Off
63
Finals
17.12.2022 15:00
Khalifa International Stadium
L61 vs. L62
Play Off
64
Finals
18.12.2022 15:00
Lusail Stadium
W61 vs. W62
Play Off
C:\ProgramData\Alteryx\Engine\Engine_9944_131daab9a79b4dab893c2d7e8d3b0113_\Engine_9792_9e53e6f1182c473f9e440053314a92f9_.yxdb
Single
Profile
C:\ProgramData\Alteryx\Engine\Engine_9944_131daab9a79b4dab893c2d7e8d3b0113_\Engine_9792_55f82e2456c04b558c3daa56d54c80a6_.yxdb
Single
Profile
Argentina
200000
Brazil
200000
Mexico
200000
Saudi Arabia
200000
Cameroon
160000
Germany
160000
Portugal
160000
Qatar
160000
Serbia
160000
Uruguay
160000
Al Rayyan
23
Lusail City
10
Al Khor City
9
C:\ProgramData\Alteryx\Engine\Engine_9944_131daab9a79b4dab893c2d7e8d3b0113_\Engine_9792_cc0867ad12db4db89e0f045194b16d79_.yxdb
Single
Profil
Location
Stadium Name
Date
FindWhole
Append
Match
ParseComplex
Match
Warn
Round Number_Matched
False
False
"Team2"
False
False
True
False
False
False
False
False
False
upper
Warn
Simple
Contains
Group/Phase
True
fixed
2022-12-19 13:10:09
0
Group
2022-12-19 13:10:09
2022-12-19 13:10:09
Contains([Group/Phase],"Group")
Sum_Capacity - Descending
First
10
First 10
Location
Stadium Name
City
FindAny
Append
Count - Descending
First
3
First 3
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.”
Horizontal
challenge_349_start_file