We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #271: Dynamic Double Dip

AkimasaKajitani
15 - Aurora

My solution.

 

Spoiler
I made 3 solutions.

AkimasaKajitani_0-1623078588873.png

 

apathetichell
16 - Nebula
Spoiler
Included a third way with a batch macro which was definitely the most fun... 2021-06-07 (1).png

joelmiller66
7 - Meteor

For the Seinfeld fans ... 

271 meme.jpg

Spoiler
Challenge 271 Image.png
Maskell_Rascal
13 - Pulsar

Here are my two solutions! I went with a more dynamic/scalable method for Method 1, and then decided to do a single tool solution for Method 2 using the Formula tool. 

 

Spoiler
Maskell_Rascal_0-1623088598969.png

 

Fun challenge!

 

Cheers!

Phil

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1623093520428.png

 

cchandler21
Alteryx
Alteryx

Solution attached

ggruccio
13 - Pulsar
13 - Pulsar

Involved some thought!

 

Spoiler
ggruccio_0-1623095764968.png

One was to create a simple formula - then reorder - second way was to transpose the data and join the cost and tax side-by-side then calculate the rate and crosstab/dynamic replace the field headers/names.  Used expect equal to verify that both matched the solution.

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission.

PhilipMannering
14 - Magnetar
14 - Magnetar

My solutions attached..

 

Spoiler
PhilipMannering_0-1623105110821.png

 

DaisukeTsuchiya
12 - Quasar
Spoiler
キャプチャ.JPG