Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Challenge #1: Join to Range

siddharth_28
8 - Asteroid

Re: Challenge #1: Join to Range

Elias_Nordlinder
11 - Bolide

Weekly Challenge - Join to Range

 

Spoiler
Elias_Nordlinder_0-1626079099825.png
BenoitC
Alteryx
Alteryx

Done ! I used formula tool with multiple conditions + Find And Replace + Summarize

Benoit Conley

Sales Engineer
Alteryx, Inc.

nravik
11 - Bolide

This was fun! 

Spoiler
Spoiler!Wk #1.PNG
nravik
11 - Bolide

This is great @BenoitC !

Jotigautam
10 - Fireball

My solution

pdave87
11 - Bolide

 

Hi @GeneR and everyone,

 

I have attached my copy, however I had to refer solution after analyzing my approach i.e. trying to create 'Area' using "if" condition on postal code from input1 but that didn't work. Has any one found same solution with difference approach? i.e. joining to range without using "generate rows"? 

 

If there is any other approach and I'm guessing there are multiple successful approach then I would be happy learn or specific with 'if' condition would be a good learning on how to expand the 'if' condition on range.

 

Stay safe and take care!

 

Regards,

Pratik

natalie_ruppi
5 - Atom
Spoiler
natalie_ruppi_1-1626732541785.png

 

Alona_Alagano
5 - Atom

my solution

marctowler
7 - Meteor

Never knew about Generate Rows so this was a good challenge to learn and give it a go

Spoiler
1 solution.PNG