Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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
I used the append fields tool to join the two data sets. I first converted the postal code to a VWstring. Then I checked if the postal code was between the high and low of the range ( which was created from lookup using a formula). Then after append fields, which does a cartesian join, I filtered the ones which had a match for the postal code being between the high and low and once I got the tru set, doing a summarize was easy. It matched the output.YAY!
Spoiler
This is how I solved this challenge.
I used the 'Text to Columns' tool to split the Range column into a Min and Max Postal Area. I then used the Advanced Join tool to 'categorize' each Postal Area into the appropriate Range.
I used the 'Text to Columns' tool to split the Range column into a Min and Max Postal Area. I then used the Advanced Join tool to 'categorize' each Postal Area into the appropriate Range.
1st time weekly challenge poster.
Spoiler
I had a similar solution to the solution file, the only difference was how I used the Generate Rows tool. I updated an existing field rather than creating a new one.
Trying to complete all challenges so lets start from 1.
Challenge 1 Done
Spoiler
Workflow
Thanks & Regards,
Allwyn Thomas
