Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

General Discussions

Discuss any topics that are not product-specific here.

MarqueeCReW Quick Lesson: Performance Profiling

20 - Arcturus
20 - Arcturus

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 restart. Order shall return.
Please Subscribe to my youTube channel.
17 - Castor
17 - Castor

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 😀