Build Features Tool Icon

Build Features

Version:
Current
Last modified: March 24, 2021

Use Build Features to create features and establish relationships between data in separate tables. The tool uses primitives to build features from the data you provide.

Tool Components

The Build Features tool has 2 anchors.

  1. Input anchor: The input anchor connects to the data streams you want to build features from. The 2 angle brackets on the input anchor indicate that it accepts multiple inputs. 
  2. Output anchor: Use the output anchor to pass the data that includes the features you build downstream.

Configure the Tool

To use the Build Features tool, you have to configure options that manage relationships between your data and manage primitives that build the features from your data.

1. Manage Relationships

  1. Select the Manage Relationships tab. You should see this section by default when you open the Configuration window for the first time.
  2. Select the Target Table.
  3. Choose a Primary Key from the dropdown. You only have to choose a primary key for the target table, but selecting a primary key for other tables might help you create relationships, depending on how many relationships you want to create.
  4. Define parent-child relationships between tables in your data. Choose the Parent table and its Key, as well as the Child table and its Key.
  5. Select New relationship if you want to add more than one parent-child relationship.

2. Manage Primitives

  1. After you've created all the relationships you want, go to the Manage Primitives tab.
  2. Search for the primitives you want to build from the data. To see a list of primitives with their explanations, visit this page.
  3. Check the box next to those primitives.
  4. Choose the Table Depth, which specifies how many tables the tool should look at when using aggregation primitives. Those kinds of primitives build features by combining, or aggregating, data from multiple tables.

Understand Primitives

At a high level, primitives are functions applied to raw data that help build features from it. Those functions can either aggregate or transform the data to build features. Primitives only constrain the input and output of data, so you can apply the same features in many different scenarios. For example, 1 primitive measures the average time between 2 dates. You can apply that primitive in many different scenarios, like to measure the duration of semesters, seasons, or tenures. In that way, a single primitive can be used in different contexts to answer different questions about your data. For more information about how primitives work, visit this page.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.