Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Challenge: 5th grade math

Highlighted
Founder
Founder

Another real 5th grade math problem that is easy to solve in Alteryx:

 

"Stretch Your Thinking: I am a number less than 3,000. When you divide me by 32, my remainder is 30. When you divide me by 58, my remainder is 44."

 

How many tools can you solve it in?  Can you get the answer without a Filter tool?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@Ned,

 

Spoiler
IIF(Mod([Number], 32) == 30 && Mod([Number],58) ==44,[Number],null())

I solved it in 6 tools and took your no filter challenge for extra credit.

 

Spoiler
Screen Shot 2017-02-19 at 4.12.08 PM.png

Thanks for the distraction!

 

m

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
16 - Nebula
16 - Nebula

Fun distraction

 

4 tools (no filter, and 1 is a browse)

 

Spoiler
2017-02-19_22-27-57.jpg
Highlighted
16 - Nebula
16 - Nebula

@Ned If you just want one number that meets the criteria, it can be done in two tools plus a browse

Spoiler
Untitled.png

It's essentially combining the Mod formula from @MarqueeCrew with the generate rows from @jdunkerley79

Highlighted
12 - Quasar

I'm impressed with the elegance of the other solutions. Here is how I approached it before looking at other's. Looks really clunky compared to James' idea. Really missed not using the filter to try to get the number out.

 

Spoiler
NumberProblem.png
Labels