London, UK

  Have you been to Inspire? If you haven't, now is the time!  Whether it will be your first time or not, don't let this opportunity slip away. We have a special code for all our User Group members! Use Inspire24UserGroup for a 25% discount! Register here! On top of being a conference to level up your problem-solving skills with analytics automation and AI, this year we brought back Free Alteryx Certification at Inspire. Yes, you read right: Registered conference attendees can take the exams on-site for no additional cost.  Enjoy an immersive learning experience as you make new memories and lifelong connections.  Let me know if you have any questions! You can reply to this post on the comments section below, send me a private message, or email me directly at flavia.brancato@alteryx.com.  I can't wait to see you in Vegas! Flávia Brancato Global Program Manager ... View more

Hi All,    For our 33rd London Alteryx User Group we were welcomed by the Alteryx team at their lovely new offices in Aldgate. @paul_houghton kicked the night off with some of the latest insights from the Alteryx Community followed by some fantastic presentations by our speakers.   Our first speaker of the night was @OllieClarke, Consultant Support at The Information Lab. Before joining The Information Lab, Ollie was a musician but quickly found his love for data and enrolled for The Data School. It was here where Ollie was first introduced to Alteryx and has since advanced his career to becoming an Alteryx Ace. As Ollie still works at TIL, he is frequently asked by the latest students for advice and guidance. The most common questions (and Ollie's responses) are as follows:  Why did you get good?  Job Requirement Enjoyable Gamification of Weekly Challenges The Tool Itself How did you get good? Weekly Challenges Client Work  Personal Projects CoE/Community Collabortation What helped? Collaboration Colleagues Community  Competition  Conference It was clear from Ollie’s answers that he utilised the materials that are freely available on the Alteryx community, in particular, the weekly challenges and the learning materials. Ollie is also a big fan of collaboration whether that be with his colleagues at work or the wider Alteryx Community via conferences and user groups. Our second speaker of the night was @Joe_Lipski, a UK Practice Lead at Aimpoint Digital. Joe has been using Alteryx since his very first internship with the Javelin Group in 2011 and is still actively using it in his latest role at Aimpoint. Joe attended one of the very first Alteryx conferences back in 2014 where he was awarded his Alteryx Ace status for the very first time, a title that he still retains to this day. Joe has shown his support to not only the wider Alteryx community, by helping others and speaking at various conferences and events, but he has also been a massive support to our local London community by co-hosting the London Alteryx User Groups. After many years of organising speakers, hosting locations and pizza, Joe has made the decision to step down as a London User Group Leader. To celebrate Joe’s dedication to the role, we asked him to take us though his Alteryx life and how it has evolved his career. Joe has spoken at multiple events over the years covering a wide range of topics but he ended his talk with 5 key points on what has helped him get to where he is today: Be Passionate Be Proactive  Start Communities  Help Others Level Up  Know and Promote Your Value   @paul_houghton was back on stage as our last speaker of the night where he shared some very helpful tips and tricks about optimising a workflow. Paul showed the User Group a workflow which initially took 18 minutes to run (luckily he ran it well before his presentation started!).  By following a 5 step thought process he was able to dramatically reduce the time of the workflow down to around a minute: Where are the bottlenecks? Evaluate your data sources  When are you filtering?  Check your output use Optimise Spatial and Predictive processes He then shared some key actions that a user could do to help optimise the workflow: Workflow Profiler  Remove Unnecessary Fields  Limit Amount of Data  Eliminate Browse Tools  Optimise Record Size If you're after some more hints and tips then you're in luck. Paul has recently released a book which is available to buy on Amazon: https://www.amazon.co.uk/Data-Engineering-Alteryx-engineers-practices/dp/1803236485    What’s next for the London User Group? We are excited to announce that our next user group will take place on 13th June 2024. The location has still to be confirmed but watch this space!    📢 If you would like to become a co-leader of the London Alteryx User Group leadership team, contact usergroups@alteryx.com.  ... View more

On the day of the event, join here: https://community-alteryx.zoom.us/meeting/register/tJAld-ivpzkjHdElpoOWBPw_OoaFDN5hmRUp Join Us at the #33 London Alteryx User Group Event! Date: 26 March Time: 6:00 PM (BST) Location: Hybrid - Join us in person or virtually.  ** LOCATION UPDATE ** Alteryx Offices Floor 4, 133 Houndsditch. London Agenda: Ollie Clarke - Developing your team Learn valuable insights on team development from @OllieClarke  Joe Lipski - The History of Joe, how Alteryx has evolved my career Discover @Joe_Lipski's journey and how Alteryx has shaped his career. Tips & Tricks - Optimisation hints and a practical thought experiment Get practical tips and tricks for optimizing your Alteryx workflows. Networking Connect with fellow Alteryx users and expand your professional network. Don't miss out on this valuable opportunity to enhance your Alteryx skills and network with like-minded professionals!     Register on the top right to save your spot!      If you have any questions, drop a comment in the post below ... View more

Hey, Could you please help me to extact the voucher number for below examples:-    Anything after EMR|LRN|ARB|NRT|TTT in regex   Description Expected Result  Account payable 126 EMR 00012345 dddd  00012345  BCX payable 157 LRN 00012512 12357 00012512 ARB 1234566 ddd799 1234566 NRT 12345600 89766 dddd   12345600 TTT 1234565  55566 ddddd    1234565   Thanks, Neeta ... View more

Hi All,   Please help me alteryx tool:-   Date Number (desire result) 2023-01-11 44,937.00 2023-01-03 44,929.00 2023-01-27 44,953.00     Thanks, ... View more