ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

MarqueeCReW Quick Lesson: Performance Profiling

MarqueeCrew
19 - Altair
19 - Altair

Here's a "quick" video explaining how I approach performance profiling.  In exploring an Alteryx challenge (posted by @vineetamishra ) both @PhilipMannering and I provide solutions to the following post:  Regex-extracting-after-last-underscore 

 

Philip followed the instructions and responded with a RegEx expression:

 

REGEX_Replace([Example String], ".*_(.*)", '$1')

 

 

I followed with a nested string function: 

 

Right([Example String],Findstring(ReverseString([Example String]),"_"))

 

 

Philip countered with a different string function (using getword()):

 

reversestring(getword(replace(ReverseString([example string]), '_', ' '), 0))

 

 

I followed with a "but mine is fastest" argument rebuttal.

 

How and why did I think that mine was fastest?  Please watch (9 minutes) and find out!  Please comment below on how you would test or give me any feedback.

 

 

Thank you to @vineetamishra and @PhilipMannering for your contributions.

 

Cheers,

 

Mark

 

Spoiler
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Emil_Kos
15 - Aurora

Hi @MarqueeCrew,


Very interesting. Thank you for sharing.

The key highlight for all the people watching this. Regex is awesome but it takes up a lot of resources 😀