alteryx Community

# Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

## Converting Values from Scientific (E) Notation

Converting values from scientific (E) notation

## How To: Remove Leading Zeros From a Field

How do I remove leading zeros from a field? Use the Formula Tool and the TrimLeft() function to remove leading zeros!

Is it possible to add a comment to an expression used in a Filter or Formula?

## How to Create Date from Excel Date Formatted as Number

Creating Dates from Excel Date Formatted as Number

## Floating point numbers are surprisingly strange

This article reviews the usage and common pitfalls of floating point numbers.

## 20 Token RegEx Expressions For The Newbie

My journey with Regular Expressions (RegEx) started because I was lazy. In advanced use, being lazy or greedy is all part of the RegEx experience.

## An expression must be specified.

Troubleshooting the error: An expression must be specified.

## How To: Create a new date field based on a Formula

Creating a new date field based on a formula

## Changing Single Quotes to Double Quotes in an Expression

How to Change Single Quotes to Double Quotes

## Tableau Function Translation Guide

Tableau Function Translation Guide

## How To Find The Last Day Of Any Month In Alteryx

How To Find The Last Day Of Any Month In Alteryx

## Filter Using String Data

There are a handful of ways to search for a particular string within a data field.  If you want to perform a query, identifying records with a particular string field within a data field: Use the Filter tool: the result will be two streams - those records that meet your filter criteria and those that do not. On the Functions Tab, expand the string tree and select FINDSTRING(String, Target) Replace the `String` parameter with the field name Replace the `Target` parameter with the value you are looking to identify Finish the expression with !=-1 which will separate the true values from the false ones. Example - If you are trying to identify all of the customers with Joe in a data field [Name] : FINDSTRING([Name], "Joe")!=-1 The records that meet this criteria will be output from the True anchor ([Name] contains the value "Joe"). All other records will be output from the False anchor. This function can also be used in the Formula tool; if for example you want to populate a different data column based on the [Name] field, you can use the FINDSTRING in an IF statement.  Example: You would like to classify your data in a new field based on the instance of customers with Joe in a data field [Name] :   IF (FINDSTRING([Name], "Joe") != -1) THEN "JOE Customer" ELSE "Other" ENDIF   This will populate a new data field with "JOE Customer" if the field "Name" contains "Joe" otherwise it will populate that field with the value "Other" In the Formula tool, add a new field by selecting + Add Column, or choose an existing field to update. Make sure the appropriate Field Type and Size is also specified On the Functions Tab, expand the Conditional Tree and select IF c THEN t ELSE f ENDIF On the Functions Tab, expand the String tree and select FINDSTRING(String, Target) to replace c Replace `String` with the field name Replace `Target` with the string you are looking to identify Finish this part of the expression with !=-1 which will separate the true values from the false ones Replace "t" with the desired value to populate the new field if the condition is met: "JOE Customer" Replace "f" with the desired value to populate the new field if the condition is not met: "Other"

## Date Conversions

How do I get from a date like this...MM/DD/YYYY...to where I have the day integer, the month name, and the year in three different columns?

## Writing Formulas to Excel

how to reference other cells when creating formulas in excel

## Currency formula, or adding the comma separator

If you're using the Formula Tool in v11.0+, be sure to familiarize yourself with the tool's interface redesign!

## Search for Keywords in a Text String

This article features a workflow that will allow you to search for keywords within a column of text strings.

## Boolean versus Positional Results

Boolean versus Positional Results

## Mapping: Generate Multiple Maps Automatically Using the Grouping Field

How do we do this? Read on.

## How to Find the Next Specified Day from a List of Dates

If I have a list of dates, how can I find the date of the next Monday for each date?