Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #238: Ideal Gases Don't Exist

KaneG
Alteryx Alumni (Retired)

I can imagine there are a bunch of different solutions to this one. I'm normally not that concerned about using too many tools, but this one required more interface tools than non-interface. It'll be interesting to see how many different ways people lay out their interface tools!

 

Spoiler
I went with a simple way of selecting which variable to calculate... use another input. It makes the formulas easier I think. Error message is handy and I'm sure there's a solution similar to (ToNumber([#1]) + ToNumber([#2]) + ToNumber([#3]) + ToNumber([#4])!=3). I left my IIF replace formula solution as it worked without having to troubleshoot the ToNumber.



KaneG_2-1603328313393.png

 


 

KaneG_1-1603328223270.png

 

ArtApa
Alteryx
Alteryx

This is the first time I've built a one-tool-solution to a Weekly Challenge:

 

Spoiler
ArtApa_0-1603345759917.png

 

kelvin_law1
9 - Comet

Here is the solution:

Spoiler
kelvinlaw_0-1603350792033.png

Analytic App Input with Result:

kelvinlaw_1-1603350919637.png

Error for not selecting 3 checkboxes:

kelvinlaw_2-1603350981700.png

 

 

hanykowska
11 - Bolide

Learned a few things in the process, thanks!

 

I was considering making a flexible solution that would be easy to adapt for other calculations, but decided against it and went for a quick win 😅

 

Output:

Spoiler
238_app_in_action.gif

Workflow:

Spoiler
hanykowska_0-1603352092582.png

 

mbogusz
9 - Comet
Spoiler
2020-10-22 08_18_46-Greenshot.png
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 238 is done!

 

Spoiler
Jonathan-Sherman_0-1603391540498.png

 

ehughes
9 - Comet
Spoiler
It looks like there's an error but it runs fine in the app 🙂
Img 238.png

T_Willins
14 - Magnetar
14 - Magnetar

Instead of adding the error I went the the preventative control:  Let the user select the calculated variable and let them know the amount in the selected variable input will be ignored for the calculation.  The Error Message tool is useful, but I would rather make the workflow error proof instead.

 

Spoiler
Workflow 238.jpg

 

ConradW
8 - Asteroid

Back on the challenges

JustinBabbitt
Alteryx
Alteryx

Apps and Error messages are fun! 

Spoiler
JustinBabbitt_0-1603720485225.png

 

Justin Babbitt