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.

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 #187: Generate Prime Numbers

pjdit
8 - Asteroid

Here is my very un-mathematical solution.  works up to 1000, but would probably blow up a computer if ran for a large number.

Spoiler
challenge_187_PD spoiler.JPG
ddiesel
12 - Quasar

My solution:

 

Spoiler
Haha, my CLUNKY solution. I really enjoyed seeing other (MORE EFFICIENT!) solutions to this challenge.

Capture.JPG

Declanh94
5 - Atom
Spoiler
Declanh94_0-1572542698415.png

First weekly challenge!

data_rachel
8 - Asteroid
Spoiler
187a.PNG
187macro.PNG


 

tonypreece
10 - Fireball

First challenge completed!

 

Spoiler
weekly challenge 187 solution.png
AlexSimpson
7 - Meteor

Good fun! Solution is attached and available below 🙂

 

Spoiler
Chalenge 187 Solution.png

 

Glycogenolysis
6 - Meteoroid

A little of a mess with the flags & logic in the formula tool, but surprisingly easy!

 

I've never used the generate Rows before - thought it would be better to use it in a batch macro - but the duplicated Append Fields method is much easier.

GGard
6 - Meteoroid

I tried two different versions - Brute force and using the method 'Sieve Of Eratosthenes'

The first one crashed around 100,000 records while the second can output results for 10M of records in 1 minute.

 

GGard_0-1572605207247.png

Kenda
15 - Aurora
15 - Aurora
Spoiler
Love a good math problem!
Capture.PNG

jcktwnsnd
6 - Meteoroid

My attempt. Couldn't think how to tackle this easily using Alteryx tools, so had a go using the Python tool. Getting a strange error though regarding metadata, but outputs the answer.

Spoiler
jcktwnsnd_0-1572612555831.png