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

Sissy
5 - Atom

I'm new to the community and the software.

 

Try my best to catch up and learn as fast as I can.

aishraq21
5 - Atom

Hi,

 

New to solving the challenges. But great fun 🙂

seven
12 - Quasar

My solution with a data validation piece at the end


Annotation 2019-07-28 205329.png

Nikos_I
5 - Atom

Hi Kacper,

 

Just started Altreryx, 

 

Did the same thing as you because I didn't know that the tool "Generate rows" existed.

 

I think this solution is a bit more data intensive, from the one proposed, because from 2678 rows we go to 13390 in order to pose the filter formula and separate out the data. On the other hand, the "Generate rows" way create less: 5-->20 rows and then the join tool does all the rest. I am not an expert but there is something to think about.

 

If there were a lot more postal ranges and the ranges were bigger then I think the generate rows would be also expensive.

 

Liked the test part.  Nice work.

 

Nikos

sara-hamdoun
7 - Meteor
Spoiler
Spoiler

Challenge 64.JPG

Hobbs1292
7 - Meteor

Here's my solution to this one. Thanks, Will

AntoineR1509
7 - Meteor
 
qb
7 - Meteor

Hello! Here is my solution for good ol' #1.

Spoiler
challenge-001.PNG
Niklas
8 - Asteroid

All the way back to number 1, let's see how long the momentum holds...

Etienne
8 - Asteroid

Solution attached