Get startedGet started for free

Length and position-based formulas

Next, let's create some new fields that will be useful in setting up reports and honing in on the data. We will need to extract the year from the Sale Date field, as well as create a "Type" field based on the Building Class.

If you lost any progress, load the 3_1_PadLeft_and_Numeric_Formulas.yxmd from the Exercises folder on the Desktop.

This exercise is part of the course

Data Preparation in Alteryx

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise