Euleryx Project 1 - Multiples of 3 or 5

[Pilsner]

Euleryx Problem 1 - Multiples of 3 or 5

Here's my full workflow and Answer:

Spoiler

Answer: 233168  

Method:

With this being the first problem in the series, we’re kicking things off with a relatively simple challenge. Typically, the challenges do get harder (which will likely become clear by Problem 3), but rest assured, we will do our best to explain what we’ve done.

That being said, the solution below is just one way to solve this problem; there are many different available routes! 

 

 

Here's how I tackled this problem:

1. I began by creating two lists, one list containing all the multiples of 3, and the other list containing all the multiples of 5. I found the Generate Rows tool to be ideal for this task.
   
   
2. Using both the Union and the Unique tool, I created a list of all the distinct multiples of 3 or 5 (below 1000).
   
   
   
   
3. Finally, to sum the column, I used the Summarise tool.
   
   
4. Submit your answer to the Project Euler website. 
   
   

Congratulations, you’ve finished your first Project Euler challenge! Looking forward to seeing you all this time next week for Problem 2.

 

Summary

In just 3 simple steps, we have already found an answer to the first Project Euler challenge. Please feel free to share your solutions below. I hope you enjoyed the first challenge.

[Carolyn]

Solved in 3 tools. Like others, I can't read good and included 1000 the first attempt :)

Spoiler

[caltang]

Did it with 3 tools! @Pilsner This is an excellent initiative. Should be its own Alteryx challenge category. 

 

[gawa]

@Pilsner Love this project, thanks!

2 tools: Text tool + Formula tool

Spoiler

I applied Gauss Summation. and De Morgan's laws.
Gauss Summation requires the first and last component of number sequence to know the summation. 
3+6+...+996+999=(3+999)*333/2
5+10+...+995=(5+995)*199/2

According to De Morgan's laws, the set of multiple of 3 and 5 is; Set{multiple of 3} + Set{multiple of 5} - Set{multiple of 3*5}

[abacon]

Really cool project, excited to participate in the rest of them.

Spoiler

[Yoshiro_Fujimori]

Sorry to be late.

I tried in two ways.

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

[Pilsner]

@Yoshiro_Fujimori I saw your filter tool, which briefly confused me, then I thought that's very clever:

Exploiting the fact that 0 * anything = 0, instead of using an OR statement, is a nice trick.

[DaisukeTsuchiya]

I just solved without tool golf.

Spoiler

 I simply used the Generate Row Tool to find multiples of 3 and multiples of 5, and then used the Unique Tool to remove duplicates. It’s enlightening to see everyone's various ingenious approaches.

[martinson]

Great Challenge!

Spoiler

Answer 233168
Time 3:00