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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
