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