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

syazsollah
5 - Atom

My solution

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

  • This could be a great challenge if you are trying a crack at understanding what's the Transpose vs. Cross Tab tool understanding
  • Dynamic Rename allows you to add prefixes/suffixes to all fields at once should you have the need.
Spoiler
dhavaldoshi_0-1623394595668.png

 

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1623410016972.png

 

Fun challenge to force yourself to come up with a different approach.  My initial effort at an alternative wasn't quite different enough, so I called this Option 1b.

saimathangi
7 - Meteor

Attaching my solution

Spoiler
saimathangi_0-1623409302626.png

 

Jonny
11 - Bolide

nice challenge, found 1 solution pretty easy but struggled for some time to find a second one. got inspired by the visuals of @DavidThorpe 's solution and ...

 

Spoiler
learnt about two new tools in "Make Columns" and "Arrange" I didn't know much about it!

Jonny_1-1623421705029.png

 

 

DataHabanero
9 - Comet

Ready!

AngelosPachis
15 - Aurora

My solution for challenge #271

 

Spoiler
AngelosPachis_0-1623437605474.png

 

amir_alteryx_2021
6 - Meteoroid

My first challenge completed. 

To dip or not dip that is the question. 

 

Spoiler
Capture-mymethod
DawnDuong
12 - Quasar
12 - Quasar

Interesting case. First time I actually use the Arrange Tool. Thank you!

Emil_Kos
16 - Nebula

Hi,

 

Same for me @DawnDuong! Arrange tool is awesome!

 

Emil_Kos_0-1623583777727.png