Challenge #1: Join to Range

[_Viktoria_]

Solution

[AnnaELawrence]

Solved!

[pnjoroge]

Thanks for posting these challenges. These are a good way to get into using this product. I have my working solution attached here.

[_Viktoria_]

Improved solution; i uploaded a very bumpy one yesterday, todays is much better i believe :)

[KirkN]

My solution attached.

[klturi421]

My solution to weekly challenge #1

[prashant007]

Hi,

My solution breaks range into 2 columns and that is used to decide which region needs to be assigned

[Prasad_Galinde]

My first Challenge solution

[ss0061933]

Learned 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 ) 

[Sskrbec]

Solution