There are various tools in Alteryx that allow for a broad variety of calculations. You will utilize multiple expressions to create new data columns, update existing columns, and reference data to qualifying rows. You will use more rigorous expressions to maximize the potential of the Formula, Multi-Row Formula, and Multi-Field Formula tools. The goal is to gain a solid foundation in the different types of Formula tools so you can write powerful expressions.
This chapter will cover the following topics:
- Multi-Row Formula
- Multi-Field Formula