core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
My solution
Nice challenge, this was my first time using the Generate Rows tool 😊
Hello,I'm somewhat late on this one. But I'm new to Alteryx and would want to hear your comments on my solution against yours.
My solution attached.
Used text to columns to split the postal range into 2 columns, then used generate rows to expand the lookup table, then joined the data and summarized accordingly.
Here are the two solutions I found for this challenge.
Fun exercise. First time I have used the Generate Rows tool, so it was good to learn.
This is origin of history of weekly challenge...
As cannot edit last post, upload solution as a new post