Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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 #122: Think Like a CSE...Ranking Data

Ladarthure
14 - Magnetar
14 - Magnetar
‎06-25-2018 09:54 AM

a simple solution for this one :)

challenge_122_start_file.yxmd
Reply
0 Likes
Laabsky
6 - Meteoroid
‎06-25-2018 10:03 AM

At first I was a little stymied, but then I got it in 3 tools.

 

 

Spoiler
Capture.JPG

 

challenge_122_finished.yxmd
Reply
0 Likes
kcgreen
8 - Asteroid
‎06-25-2018 10:04 AM

Done

 

Spoiler

 

122.JPG

 

challenge_122_MultiRow_Order.yxmd
Reply
0 Likes
svenk
8 - Asteroid
‎06-25-2018 10:05 AM

My Solution!

Challenge_122_SVsolution.yxmd
Reply
0 Likes
bdaniels
8 - Asteroid
‎06-25-2018 10:26 AM

solution

 

Spoiler
Screen Shot 2018-06-25 at 10.25.35 AM.png
challenge_122_start_file.yxmd
Reply
0 Likes
ggruccio
ACE Emeritus
ACE Emeritus
‎06-25-2018 10:26 AM

Love seeing all the participation in the weekly challenges!

challenge_122_gg_finish.yxmd
Reply
0 Likes
ckings
7 - Meteor
‎06-25-2018 10:48 AM
Spoiler
I really struggle with the multi-row tool so this was a great challenge! Two tools but took a long time to get my multi row to work though.
wk122.PNG
challenge_122_CAK.yxmd
Reply
0 Likes
ponraj
13 - Pulsar
‎06-25-2018 11:21 AM

was able to produce the desired results using record ID and Multi row formula tool. 

 

workflow.PNG

challenge_122_solution.yxmd
Reply
0 Likes
dlrustvold
5 - Atom
‎06-25-2018 11:38 AM

My first posted solution (last week's is still too much of a mess).  I went with a summary tool rather than a multi-line formula, and did some superfluous data prep to be robust to a general input.

 

L

challenge_122_start_file_dlr20180625.yxmd
Reply
0 Likes
SnehaMatte
5 - Atom
‎06-25-2018 11:44 AM

More of the usual I guess.

challenge_122_SnehaMatte.yxmd
Reply
0 Likes
Live Weekly Challenge