From the course: Introduction to Alteryx
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Get familiar with the Formula tool - Alteryx Tutorial
From the course: Introduction to Alteryx
Get familiar with the Formula tool
- [Instructor] After using the select tool to limit the number of fields working within the workflow, let's grab a formula tool from the favorites bar to concatenate the text from the city and state fields to create a unique identifier called location. In order to add this new tool onto the workflow between the select tool and the browse tool, we may need to stretch these tools out a little bit, one direction or another. Remember that the Alteryx canvas space is as large or as small as we need it to be so we can have as many tools as we want. So definitely space them out so you can easily read through the annotations and you can see the connection progress. And with this new formula tool, as we look at the input anchor, we can see the data table as it flows in. We will not be able to see the data table on the output side until we hit the run button. So I'll switch my view back to the input anchor of the formula tool.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.