This article is by David Ha and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/Splunk-will-it-Alteryx/ba-p/554043#
What is Splunk?
Although Splunk has expanded to many software products, in this blog we will focus on Splunk's core product offering, which is a technology for collecting and analyzing machine generated data.
This article is by Mat Budden and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/Hey-Alteryx-Turn-On-the-Light-Actually-Why-Don-t-You-Just/ba-p/555041#
In a recent conversation with my Alteryx Account Executive, we were discussing things you could do with Alteryx, and to be fair, the list is enormous.
This article is by Kenda Barnes and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/This-Feature-That-You-Didn-t-Know-About-Will-Change-Your-Life/ba-p/548446#
When you open Alteryx Designer, the default layout direction on the canvas is horizontal.
This article is by Robert Lenius and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/Tax-Reporting-From-ERP-To-Inbox/ba-p/547167#
With tax requirements constantly changing there can come a need to have ERP data or alerts automatically come into your mailbox, eliminating the need to manually pull and check this information on a routine basis.
This article is by Susan CS and originally appeared on the Alteryx Data Science Blog here: https://community.alteryx.com/t5/Data-Science-Blog/Repairing-Broken-Models-or-Not-During-a-Pandemic/ba-p/558570
What do you do when you have an amazing, even award-winning, model based on years of work that is suddenly wrecked by a global pandemic?
Sound familiar?
Well, if you’re with the Delphi research group at Carnegie Mellon University, you pick yourself up and move on to think creatively about the next big problem.
This article is by Ben Moss and originally appeared on the Alteryx Data Science Blog here: https://community.alteryx.com/t5/Data-Science-Blog/Alteryx-Your-Discover-Weekly-A-Practical-Application-of-K/ba-p/564059
Carly Rae Jepsen or Napalm Death
So, let’s review how we can apply KNN in Alteryx in order to allow us to determine whether a track is by either pop artist Carly Rae Jepsen or grindcore band Napalm Death.
This article is by Ben Moss and originally appeared on the Alteryx Data Science Blog here: https://community.alteryx.com/t5/Data-Science-Blog/Alteryx-Your-Discover-Weekly-A-Practical-Application-of-K/ba-p/563359
What Is K-Nearest Neighbours (KNN)?
The Wikipedia definition is:
In pattern recognition, the k-nearest neighbors algorithm (k-NN) is a non-parametric method used for classification and regression.
This article is by Robert Lenius and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/Verifying-Tax-IDs-With-REGEX/ba-p/529729
Have you ever found yourself putting data into some online application only to have it fire back that the format is incorrect? This could be things like a phone number, address, or in the bad example on the right, a name .
Typically, this is done through regular expressions, also known as REGEX functions.
This article is by CP Lewis and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/Automate-the-Repetitive-Stuff-to-Free-Yourself-Up-to-Focus-on/ba-p/526300
You know how amazing it would be to free up some of your time and look into more advanced topics in Alteryx or look into crazy, off the wall problems? You are not alone! I have wanted to continue looking into this and that in my spare time but for the longest time, I couldn’t. Why you might ask? I didn’t know how to automate my work from end to end and had to continue to manually do things.
This article is by Joshua Burkhow and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/5-MORE-Useful-Design-Patterns-in-Alteryx-You-Need-to-Master/ba-p/520943
Solution #6: Keeping Sort Order After a Summarize, Unique or Other Tools
Use Case:
You have data that you want to summarize or get rid of duplicates and in developing a workflow realize that the data gets automatically sorted on the output, but you would like to keep the order that the data is in or some order other than what is given, even with aggregation!
You can simply do this by adding a Record ID tool, and in the case of a Summarize tool, just use the Sort Order column as a ‘First’ or in the case of using the Unique tool just sort on that column after the Unique tool.