Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALearned the Alteryx basic course last week and attempted my first challenge today and I enjoyed a lot. Directly got a feeling like working on real-time scenario. So I used the below approach for the solution
1. Get the range1 and range 2 columns from Range for table 2
2. Cross join two tables using append
3. Get the flag for each Customer id if postal code is in range1 and range 2 , flag it 1
4. Get the count of records where flag is 1 (group by required fields )