Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #224: Mushroom for Improvement

8 - Asteroid

My Solution

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,

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|\?))

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  

9 - Comet

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!  

8 - Asteroid

Super Cool 🙂 

Alteryx
Alteryx

Thanks

Spoiler
RobertW_0-1594755246201.png

 

9 - Comet

Hi! Here my solution 🙂

 

Spoiler
challenge224.png
11 - Bolide

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

 

Alteryx
Alteryx

I didn't try to combine too many tools

 

Spoiler
KaneG_0-1594787915475.png