Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
How do you convert a string with a $ sign into a number?
View full article
Alteryx has the ability to calculate the quarter, week number, etc
View full article
When writing expressions that evaluate NULL conditions, it is a common mistake to write the syntax as: IF [FieldX] = NULL() THEN ...   After all, this is how you would write the expression in SQL.  However, the actual syntax needs to be: IF ISNULL([FieldX]) THEN ....   Keep writing those expressions!
View full article
A large component of data blending is applying mathematical or transformational processes to subsets of your data.  Often, this requires isolating the data that complies with a certain criteria that you’ve set. The Conditional functions build expressions that allow you to apply processes to data that satisfy conditions you set.   #
View full article
Alteryx’s spatial functions are not limited to the tools found in the Spatial Palette.  The Formula Tool, for example, has a variety of spatial functions that expand the Designer’s spatial capabilities beyond those in the Spatial Tool Palette.  This article highlights the Formula Tool’s ability to create spatial objects, particularly points and lines, and calculate distance using the built-in expression library.
View full article
How to create null values in a data set. 
View full article
How to call Windows User, Paths, or other Environment Variables in a Workflow.
View full article
How to Trim Numbers with a RegEx formula
View full article
How can I calculate the first and last day of the year of a date?
View full article
Full details on the addins can be found on my blog; the addins can be download from GitHub. Hopefully it will make creating some formulas easier!
View full article
Lookup the term "date" in community and you'll get 2,000 results.  Hidden in this article are Easter eggs for the finding.  Besides learning about dates, see if you can uncover the clues that I've cloaked.
View full article
The “D” notation is common to Fortran implementations and generally represents double precision numbers. This notation is much less common than the E notation, but Alteryx does recognize it.
View full article
You may have seen the modulo (mod) function used in the awesome Collatz Conjecture macro on the Gallery; here, it's used to determine the parity of the entered integer.  Depending on if the number is even or odd, a different set of operations is applied to the value.
View full article
Binary (bit level or bitwise) operations operate on one or more bit patterns or binary numerals at the level of their discrete bits. They are typically used to manipulate values for comparisons and calculations - and encryption!
View full article
Whether for mathematical or formatting purposes, you may want to round your numeric data.  Depending on the type of rounding you're looking to do, Alteryx has a solution for you!
View full article
Troubleshooting the "Unknown Function YEAR()" error, or other related Date expressions.
View full article
  Be sure to first understand that different people/organizations all have different definitions on what they mean by rounding.  Once you are clear on what you need, you can use Alteryx to round your numbers.   Example 1: Divided by the place you want to round to, use CEIL to round up, then multiply back by the place:   324 to 400 CEIL([Number] / 100) * 100   Example 2: Ceiling and floor just go to the nearest integer.  The ROUND(x, multiple) function will allow you to specify the level of precision on which to round, very similar to Excel.  But you can't specify the direction, so in your example, if your did ROUND(3425.123,1000) it would return 3000.   Example 3:  Please see the attached v10.0 workflow which is more dynamic. The text input identifies the mapping for the conversion joined with length of source input - then an expression is applied in the Formula Tool.         The final output.      More on rounding.
View full article
One trick I often use to conditionally update a field is the Boolean IIF function.  IIF is basically a shorthand version of a single condition test.
View full article