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 #78: Find the Best Housing Markets

WernerE
8 - Asteroid

Thanks, was fun as always

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-11-02 à 14.15.00.png
mikecusic
Alteryx Community Team
Alteryx Community Team

Nice, tricky parsing challenge! I highly recommend www.rubular.com for testing the RegEx. MC workflow.png

Qiu
20 - Arcturus
20 - Arcturus

Nice one!

Spoiler
en-78.PNG
JP_SDAK
8 - Asteroid

Great Regex challenge- multiple lines threw me - but finally figured that out.  I might come back and do app later.

Spoiler
JP_SDAK_0-1606670589967.png

 

tammybrown_tds
8 - Asteroid
Spoiler
tammybrown_tds_0-1609138173474.png

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my solution, haven't done the bonus part.

Tokimatsu
12 - Quasar

solved

Spoiler
2021-01-16_10h30_26.png

jdbaldwin
7 - Meteor

I can't find anyone else reporting this, but I think I am experiencing a bug.  I am at 2019.3.5.17947.  The bug manifests in both my own build and the solution workbook.

 

The data that's broken across lines, like:

 

999 13980 Blacksburg-Christiansburg-Radford,
VA 5425 5425 0 0 0

 

When I build a new line ouf ot [Field]+[Row+1:Field], I should get 

 

999 13980 Blacksburg-Christiansburg-Radford,VA 5425 5425 0 0 0

 

But I actually get 

 

999 13980 Blacksburg-Christiansburg-Radford,VA

 

This means that I am missing several rows at the end when I display the sorted results, and, for example, the NYC market line is missing (Others, too.)

 

Am I the only one?  As I said, this happens even in the canned solution file when I run it under my version.

 

OnionKnight
8 - Asteroid

Super good!!