Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI 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!
1st time weekly challenge poster.
Trying to complete all challenges so lets start from 1.
Challenge 1 Done
Workflow
Thanks & Regards,
Allwyn Thomas