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

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.






Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
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 😀