Challenge #79: Find the Closest Prime Number

[Erin]

When I first heard about this challenge during this year's Inspire conference, I honestly thought it sounded impossible. Happy to report that I completed the whole challenge without peeking at the posted solutions first! Sorry, a little braggy today. 

Spoiler

I decided to go iterative with this and learned about the mod formula:

[binay2448]

Find my solution attached...

[binay2448]

Ignore my previous solution find attached updated one.....

[MichaelPilotFreight]

Check out my solution!

[jjrbondoc]

Spoiler

[pdave87]

Awesome exercise, excited and happy to share my comments as it is finished today. Slightly different approach but totally enjoyed achieving the expected results of app and macro outputs. 

These exercises are the corner stone of my foundation in Alteryx. Long hours are worth the effort when there is a learning that involve more conceptual development. This was my first achievement wherein App and macro are paired together to achieve the output. Packaged workflow is attached for reference.

Thanks to all the SMEs. Always grateful to be part of this community.

Regards,

Pratik

[BSilverblatt]

Thanks for the challenge! Here is my solution:

[leozhang2work]

Spoiler

It works, but not the best interface.

[ARussell34]

I created an application to check first the number given and then the number immediately before and after the given value. By generating rows I was able to identify all possible values and their divisor per value between 1 and the given value. Basically checking to see all the values between 1 and the given value where they are prime and then used a final formula tool to see which value is the closest prime. I used some final reporting tools to output a small table regarding the given value, if it was prime, and what is the closest prime value if it wasn't the selected value.

[Luke_C]

Spoiler