Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA- I did split the Range into columns from 2nd Input file with Text to Column tool.
- Changed Datatype and Removed unwanted columns with Select Tool.
- Generated years from Range with Generate Rows tool.
- Then Joined the First input file and the Generated Rows output.
- Finally used the summarize tool to count the customer ID by doing the group by on Region, Responder and Sales Rep.
Attaching the solution approach.
I didn't use the generate rows tool because I wasn't really familiar with it.
But this was a good opportunity to learn it! Thanks!
I am a bit late into the party!!
Tried my best
I'm learning Alteryx by watching YouTube videos and solved my first challenge. Very much excited for the coming challenges...Great way to learn Altryx through practice Exercises.Thank you so much !!