Groups & Events

We recently hosted our Q3 Indy User Group Meeting which was a virtual meeting.  After some brief introductions, Kenda and Digan teamed up to demonstrate possible solutions to an Alteryx challenge they built.  This was very similar to the weekly challenges posted on the Community where you are given an input or set of inputs, a list of tasks that need to be completed and the final solution that you need to match.    Kenda began by demonstrating how to read in file and sheet names from a folder that contained multiple Excel files with multiple tabs in each file.  She then demonstrated how to build a batch macro that would use the filepath information to read in each of the tabs in those files.  It is always enjoyable to watch a pro build a macro!  I know Macros can be intimadating but Kenda showed just how easy they can be to build and how they can be useful in solving a problem.   Digan picked up the workflow at this point and demonstrated some of the data preparation necessary to complete the challenge.  So many good tips and tricks, and I am sure I will leave something out, so I encourage everyone to watch the attached recording to see them all.  Items that Digan covered included: IF and IIF functions RegEx Replace function using the Formula tool Complex Custom Filters which includes IN  and IF funtions    Generate Rows tool Test tool Cross Tab and Traspose One Tool examples for visual reminder of what the tools do. The test tool is not something I have used before so I really enjoyed seeing it in action.  I also appreciated seeing how the IF function was used in a filter and the setup of the Generate Rows tools.  I know I avoided the Generate Rows tool for a long time because the configuration was difficult for me to understand.  Great to see a simple use of a tool that can be confusing to new and even some experienced Alteryx users.   The workflow they used to start their challenge is attached as well as the files they input if you would like to try to solve their challenge yourself.  If you just want to look at their solution or need it as a reference while you try to solve it, it is also attached.  Be aware that the Directory tool will point to a different place for anyone that downloads these files so you will need to save the inputs down as well and reconfigure the tool for your specific file locations.    Finally, Kenda and Digan competed in a friendly game where they each proposed a tip or trick and the audience voted on which tip or trick they preferred to hear about.  The tip or trick with the most votes was then expanded upon.  Digan was a slight unofficial winner over Kenda but I think the real winner was the audience.  A lot of good information was shared on the following topics: Output Data to Tableau Control Containers Templates Run Until Selected Reference Shortcuts Crosstab - Keeping Special Characters Preserve Formatting in Excel Output Supress Blank Files in Output Data Tool I want to thank Kenda and Digan for the hard work they put into the presentations.  I also want to thank everyone who attended and participated.  These virtual meetings are always more enjoyable when everyone gets involved.  If you were not able to attend I would encourage you to watch the video and take a look at all the other attachments.  Even if you did attend you may consider watching the video again.  I almost always pick up something I missed during the live call when I rewatch these and this one was loaded with good info.  I look forward to seeing everyone in Q4.  As always, if you would like to present, host or have an idea for a future meeting please reach out to one of the user group leaders or post a meessage on our page.     @Desmond  @Kenda  @patrick_digan  ... View more

If you are attending virtually, join here: https://paychex.zoom.us/j/83618810098?pwd=Wl1NvOexlhor2wrwTv2Qz6nHo2a519.1 meeting id: 836 1881 0098 passcode: 806789 Date: Wednesday, September 17th Time: 5:30 pm - 6:30 pm EST   Agenda Introductions Gen AI Tools: @JoshuaB  Detour Tool: @caltang  Closing   Logistics for in-person attendees The Information Lab 124 E 14th Street, Floor 4 New York, NY 10003 *** PLEASE USE CIVIC HALL ENTRANCE, NOT ZEROIRVING ENTRANCE (see photo below)***     Be sure to register (top right of this post) and add to your calendar!   If you haven't already joined the NY User Group, please join so you can stay up to date on current and future meetings.   Hope to see everyone there!   New York User Group Leaders Luke ( @Luke_C ), Brendan ( @Bren_Spill ), & Mike ( @mbarone ) ... View more

https://community-alteryx.zoom.us/j/89151560910?pwd=WbGmwJiTemQsb6mfTtBu2rHt2RAdkW.1 Meeting ID: 891 5156 0910 Passcode: 871147 Hi, DFW Alteryx User Group Members!  Please save the date for our upcoming September virtual user group meeting, which will be Friday, September 26th, from 2:00 to 4:00 p.m. Central time!  We are excited to feature two highly interesting topics, delivered by two highly interesting people!   Alteryx ACE Calvin Tang is welcomed back to the DFW stage to take us on a detour, exploring the Detour Tools!  His presentation, "The Great Data Escape:  Detour Tools" explains what Detour Tools are, when and how to use them, and use case examples.  Join us to learn new ways of using these tools, creating new paths (literally) for your workflow analyses!   Next, we are honored to have Alteryx Chief Evangelist Joshua Burkhow return to our user group to showcase using AI with Alteryx!  There have been many developments and enhancements in utilizing AI within Alteryx, and Joshua will provide detailed explanations on the latest techniques, as well as answer questions.   More details will be posted soon, and please register using the "Register" button at the top right of this page.  A Zoom link will be provided to you upon registration.   Thank you to each of you for being a member of our over 950-member user group!  You help to make our group as dynamic and vibrant as possible, and we appreciate your support!  We look forward to seeing you at the meeting,   @Deanna and the DFW Alteryx User Group Leadership Team ... View more

On the day of the event, join here: https://community-alteryx.zoom.us/meeting/register/jkC-l0zLT-GtvAHslnPtbw Our next user group meeting will be a virtual event. This session is intended for those already familiar with Alteryx and many of the most commonly used tools. @patrick_digan will talk about next-level input and output techniques, RegEx (regular expressions), complex compound expressions, and a few of the lesser known but very valuable tools.  While this session is for intermediate users, all are welcome.  We hope to see you all there.  If you have any questions feel free to direct message one of us here on the Community or reply to this post.   Date: Wednesday, 09/17 Time: 12 pm EST Location: on Zoom   @Desmond  @Kenda  @patrick_digan ... View more

On the day of the event, join here: https://meet.google.com/yha-icym-ixa   Hi Everyone, we are launching the Alteryx User Group for North India - in the heart of the nation, Delhi!   Save the date for the upcoming Alteyx User Group meeting on October 3rd! Join us for an opportunity to learn more about Alteryx, expand your skills, and network with other Alteryx users.   Date: October 3rd Time: 5 pm  Virtual: Google Meet   Agenda 5:00-5:10: Welcome & Introductions 5:10-5:40: Predictive Toolkit 5:40-5:50: User Group Formation and Next Steps 5:50:-6:00: Q&A and Networking   Register in the top right corner to see the meeting information. Looking forward to seeing you there! ... View more