alteryx Community

# 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.

## Challenge #1: Join to Range

7 - Meteor

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

Spoiler
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

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

Solution via append fields

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
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.

Thanks,

Tharashasnak

ACE Emeritus

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

Spoiler
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!