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.
SUBMIT YOUR IDEA
Had 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:
