top of page

A Few Helpful Alteryx Formulas

There are so many different Formulas (or Functions as found in this helpful reference article here.) in Alteryx. Below are just a few helpful functions I use frequently;


I use this for sorting later in Tableau or SharePoint. It gets annoying if you have to sort a column with the number 1 and then 10 shows up underneath. It of course converts the format of the column to a string.

PadLeft (String, len, char)

Example: PadLeft ([orderid], 7, 0)


If you need to find the days between two dates, use this formula.


Example: DateTimeDiff([StartDate],[EndDate],"days")


This is a very helpful formula if you want to strip double or single quotes around text in a cell.

Trim(String, y)

Example Double Quotes: Trim([Quote], '"')

Example Sing Quotes: Trim([Quote], "'")


If you ever use SharePoint and need to pull in names that were stored there, you may have to use this function to strip the SharePoint syntax it adds behind the scenes.

REGEX_Replace(String, pattern, replace, icase)

Example: REGEX_Replace([PersonName], '[0-9#;]', '')

459 views0 comments


bottom of page