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.

Weekly Challenge

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

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

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

Submit Feedback

Challenge #1: Join to Range

7 - Meteor

Nice challenge, I used the formula into the generate row tool to recalculate the postal codes.


ACE Emeritus
ACE Emeritus

Nice and simple! Love it

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Alteryx Alumni (Retired)

Attached my solution.

17 - Castor
17 - Castor

Thank you.

3 differences in this version vs. the supplied solution:

- Summarized the client file to minimize the data as soon as possible

- Summarized the client data using distinct by Client ID to avoid double counting (you never know when you may have duplicates)

- Added in a simple tester at the end (joining on all fields) to make sure that every row was an accurate copy of expectation.

20 - Arcturus
20 - Arcturus

Solution via append fields

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
6 - Meteoroid

Better late than never, right?

8 - Asteroid

Hi ,


When i going through community i found this wonderful weekly exercise and started playing around. I just did my first challenge. It is a good example to show the usefulness of generate rows tool.


Loved Doing this exercise. I will try to do the rest of the exercises.




ACE Emeritus
ACE Emeritus

My solution. Figured it was time to start back at #1, see all the fun i missed from back in 2015. :)


8 - Asteroid

Hi, I'm having an issue with the Generate Rows tool.  I think it's set correctly, but I'm getting the "Parse Error at char(0): Unknown variable "RowCount" error.  Any suggestions for how to fix, my good sirs/ma'ams?  Thank you, Kurt

8 - Asteroid

Never mind--I didn't see the Loop Expression box at the bottom left of the Multiple Rows tool.  Got it now.  Thanks!