Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHad to go back to the Interactive Lesson "Writing Data" as I fell short for some of tricks required to pull this off! While a great exercise to practice batch output, I still think the output format can be improved. Will discuss this at the spoiler section.
Feel free to check my solution file and comment.
This format makes no sense for other purpose than naming the output filenames. Instead it should be normalized to optimize resources. [Product Group] and [Region] should be dropped at the join tool(Analysis Data Row might as well). [Region Key] and [Product Key] should be placed first so we can properly reference them as a compound key in a database.
My proposal and solution goes like this: