ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #271: Dynamic Double Dip

caltang
17 - Castor
17 - Castor

Done!

 

Spoiler
Screenshot 2023-06-30 133223.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Chan_Baek
8 - Asteroid

My solution.

 

Maybe it doesn't need to sort before transpose.

NMangera
11 - Bolide
Spoiler
 

workflow.png

takeaway

1. tool: multifield formula. apply the same logic to multiple fields on a conditional if statement.

2.  design pattern: record id preceding transpose tool to keep track of position post transformation

3. shortcut: right-click on on field and drag to reorder in the config pane of the select tool

gggumilar92
7 - Meteor
Spoiler
spoiler.png

my solution

gjjadhao
9 - Comet
Spoiler
spoiler#271.png

Solution is attached

BSWirayudha
7 - Meteor

Hi..

 

This is my solution. I use Arrange to replace Transpose for data transform.

 

Spoiler
BSWirayudha.PNG
aakulkarni2
7 - Meteor

Please find attached solution 

Fnumam
7 - Meteor

My solution

Adrien_Sourdille
8 - Asteroid
Spoiler
Alt 271.png
Nafiatunnisa53
7 - Meteor

Holla,, see my result..

Spoiler
wikli12.JPG