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 #366: Three Columns Are a Crowd

mg46
8 - Asteroid
‎04-14-2023 12:49 PM

Nice easy one to close out the week. :)

 

Spoiler
mguarniere_0-1681501705264.png

 

challenge_366_Michelle_G.yxzp
Reply
Coakles
7 - Meteor
‎04-14-2023 03:05 PM
Spoiler
Spoiler
Coakles_0-1681509927897.png

Good way to get more comfortable with transpose. 

 

challenge_366_start_fileMC.yxmd
Reply
0 Likes
PrachiD
8 - Asteroid
‎04-15-2023 08:18 AM

summarize, parse, record ID

submission_366 parse, summarise.yxmd
Reply
0 Likes
JosephSerpis
17 - Castor
17 - Castor
‎04-15-2023 08:32 AM

Challenge Completed

 

Spoiler
Weekly_Challenge_366.JPG
Challenge_366_Joe_Serpis.yxzp
Reply
0 Likes
jcalteryx
Alteryx
Alteryx
‎04-15-2023 06:37 PM
Spoiler
My solution.

jcalteryx_0-1681609028541.png

 




challenge_366_jc.yxzp
Reply
0 Likes
DataNath
17 - Castor
17 - Castor
‎04-16-2023 03:58 AM

My solution to #366.

 

Spoiler
DataNath_0-1681642681003.png
Challenge 366 completed.yxmd
Reply
0 Likes
sparekh1
7 - Meteor
‎04-17-2023 02:25 AM

My Solution

 

Spoiler
sparekh1_3-1681723747333.png

 

challenge_366_start_file.yxzp
Reply
ferg_smith
8 - Asteroid
‎04-17-2023 03:04 AM
Spoiler
ferg_smith_0-1681725878199.png

 

366 completed.yxzp
Reply
0 Likes
dougbaron
8 - Asteroid
‎04-17-2023 05:59 AM

nice and easy

Spoiler
dougbaron_0-1681736343535.png

 

challenge_366_final_file.yxzp
Reply
0 Likes
dougbaron
8 - Asteroid
‎04-17-2023 06:02 AM

@sparekh1 

I see that you used a join to compare actual vs expected output. I recommend getting the CREW macro set from the gallery. The Expect Equal macro is good for validating workflow output to the expected output.

 

https://community.alteryx.com/t5/Community-Gallery/CReW-Delta-Macro-Beta-version/ta-p/924519

 

dougbaron_0-1681736527636.png

 

Reply
Live Weekly Challenge