We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #124: Air Transport Network Analysis

14 - Magnetar

For a bit of variation I chose only airports in the UK sized by betweenness with . You can see how dependent the Orkney and Shetland Island Islands on Kirkwall Airport

Airport connections within the UK

Spoiler
17 - Castor

Like @ggruccio - a whole pile of trial and error - and finally came out with 275 airports.

Took me way too long to realise that there was no need to filter the "Node" input since that would just come out with degree of 0 if there were no connections!    You can see these on the chart as the circle of disconnected items around the edge!

Great challenge @JoeM and team - thank you for giving us one that forces learning of a new tool!

Spoiler

Summary:
- First filter for Domestic and get rid of bad airport IDs by converting to integer (yes, I know this is lazy)
- do the first network analysis and filter for items with degree < 500 (leaves 5 airports)
- filter the routes to and from these 5
- re-run the network analysis on these airports  275 airports connected

18 - Pollux

Canada!  Not many airports for such a big country

Spoiler

Dan

10 - Fireball

I really enjoyed this challenge! Just for fun, I added an extra bonus section that outputs a Tableau data source with a network analysis of my 3 local airports.

11 - Bolide

Cheers!

Spoiler
Here is the workflow that I came up with and the final result.
My workflowMy end solution
8 - Asteroid

Here is my solution... for some reason... the render never works on my laptop...

After having done my solution and figure out the inputs fields... I tried somebody else's solution and it does not render... any specific things to look into?

8 - Asteroid

My first exposure to the Network Analysis tool.. UK airports only

8 - Asteroid

14 - Magnetar

Here's my solution, using Iceland to speed up the rendering time.

I found the sample workflow for the Network Analysis tool very helpful in understanding how my inputs needed to be configured.

Help > Sample Workflows > Predictive tool samples > Predictive Analysis > 25 Network Analysis Tool

Spoiler
11 - Bolide

My solution 🙂

Spoiler