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 #224: Mushroom for Improvement

TiwariVaishali
8 - Asteroid

My Solution

shuman-p
7 - Meteor

Methinks i got it, but surely there would be a more efficient approach than my (over)application of the "Find Replace" tool!

 

Regards,

paulfound
11 - Bolide

Didn't have mushroom in my calendar for this today!! Funguy right here! 

 

Spoiler
PaulFound_0-1594740868228.png

Some hefty RegEx - (?:\(|^ {4})((?=\S*['-])[a-zA-Z'-]+|\w+):\s(.*=(?:\w|\?))

Spalders
8 - Asteroid
Spoiler
Spalders_0-1594742194342.png

 

Had to prefix the Fieldname before the Join in order to get the right field order

- I see now that a Dynamic Replace provides a more elegant solution  

StellaBon
11 - Bolide

I got stuck on the Dang Crosstab again, but I learned how to use it in this situation from another poster who had taken a similar path as me. Better to do it with help than give up, I suppose!  

Sudha8990AI
8 - Asteroid

Super Cool 🙂 

RobertW
Alteryx
Alteryx

Thanks

Spoiler
RobertW_0-1594755246201.png

 

RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

 

Spoiler
challenge224.png
kelly_gilbert
13 - Pulsar

I was thinking through how to keep the columns in the right order, and then I remembered a useful (but infrequently-used) tool!

 

Spoiler
kelly_gilbert_0-1594766210326.png

 

KaneG
Alteryx Alumni (Retired)

I didn't try to combine too many tools

 

Spoiler
KaneG_0-1594787915475.png