Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event 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 #343: Average App Cost

StellaBon
11 - Bolide
Spoiler
StellaBon_0-1668198620236.png

 

Thank you

StellaBon
11 - Bolide
Spoiler
StellaBon_0-1668198818046.png

 

Thank you

Pete_Rodgers
Alteryx Alumni (Retired)
Spoiler
nice regex practice 
Pete_Rodgers_0-1668444814129.png

 

Keppatawn
8 - Asteroid
Spoiler
Keppatawn_1-1668470790339.png

 

Might try it again with regex

Rupesh5
6 - Meteoroid

My solution

trung2403
8 - Asteroid

Fun challenge!

Spoiler
trung2403_0-1668583094197.png

 

eboughton
8 - Asteroid

Find solution attached.

jjimenez
8 - Asteroid

Question: After the use of the RegEx Tool (never used before) the first column separated into 2 columns. But I see how the 2 new columns changed names. 

But in the 2nd row I'm not understanding where the $7.36 is coming from. Many other I see it was part of the 1st column description, but not in row 2. I noticed this in other rows, but I thought I would just start with 2nd row. 

 

Any help on this will be greatly appreciated. 

 

jjimenez_0-1668994691572.png

 

kelvin_law1
9 - Comet

Here is my solution:

Spoiler
kelvinlaw_0-1669025726501.png

 

OllieClarke
15 - Aurora
15 - Aurora

Went for a golf based approach

Spoiler
OllieClarke_0-1669053340631.png

Tried to do as much in the formula tool as possible