Good Day Alteryx Phoenix UG Members!
We really appreciate and thank everyone who attended our October 2019 User Group meeting on 10/15/2019!
This month we went over Weekly Challenge 78 (http://bit.ly/ALTERYXWC78) Find the Best Housing Markets.
We learned how to use Alteryx’ Download tool, and dove deep on RegEx.
We explored regex101.com, which is a site that can help you explore your regular expressions on your text. We did an overview of how to test your expressions on a string. Showcased how the site till give you an explanation of the syntax and return to you the matched data. We also studied the quick reference section to get quick tips on syntax.
We also reviewed the REGEX_Match function and used it in a multi-row tool to identity where word wrap had started a new line which should be combined with the record above. REGEX_Match allows you to look for patterns in a given string and then returns a Boolean value for whether it was found.
Lastly we reviewed an innovative solution from @alex, which avoided using the RegEx tool.
Following the use case, a few Alteryx announcements were made:
The Phoenix User Group is always looking for speakers who would like to share their use cases. If presenting interests, you, please email email@example.com
Let us know the topics you'd be interested in and what you are looking forward to most from this user group. Take a few moments to fill out our survey: memberprofile.Alteryxphx.com
Phoenix Alteryx User Group leaders