Challenge #1: Join to Range

[Max06270]

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

Spoiler

[joshuaburkhow]

Nice and simple! Love it

[KatieA]

Attached my solution.

[SeanAdams]

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.

[MarqueeCrew]

Solution via append fields

[JoshK_dup_167]

Better late than never, right?

[Tharashasank]

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

[NicoleJohnson]

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

Spoiler

[kurtwz]

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

[kurtwz]

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