Results Window Data Manipulations
The Alteryx Designer Results window lets you perform several data manipulations on a given column in your dataset that you can then add to your workflow as tools. Specifically, the Results window supports the Data Cleanse, Filter, and Sort data manipulations.
Data Cleanse
The Results window gives you access to several data cleansing functions that are otherwise available via the Data Cleansing tool. To cleanse data in a given column...
Hover your mouse over a column header and select the vertical ellipsis icon to access the Data Cleanse, Filter, and Sort options for the column.
Select Data Cleanse to access the data cleansing functions. Refer to the Data Cleansing tool for detailed descriptions of these functions:
Replace Null Data: Only one of these options is available (depending on data type). Check the checkbox and select Apply to perform this action. To remove this action, uncheck the box and select Apply.
Replace Nulls with Blanks (String)
Replace Nulls with 0 (Numeric)
Remove Unwanted Characters: Check one or more of these options and select Apply to perform the actions. To remove these actions, uncheck the boxes and select Apply.
Leading/Trailing Whitespace
Tabs, Line Breaks, and Duplicate Whitespace
All Whitespace
Letters
Numbers
Punctuation
Modify Case: Select one of these options and select Apply to modify the case of all rows in the column.
Don't Modify Case: Use this option to return to the original state of the column.
Upper Case
Lower Case
Title Case
Perform your desired data cleanse actions and select Apply to add the changes to the column in the Results window.
Add Data Cleansing Tool to Workflow
When you apply a data cleansing action to a column in the Results window, you have the option to apply that action as a Data Cleansing tool in the workflow. Read the Apply Data Manipulations section below for instructions.
Filter
The Results window also gives you access to basic filtering options that are otherwise available via the Filter tool. To create a basic filter based on data from a given column...
Hover your mouse over a column header and select the vertical ellipsis icon to access the Data Cleanse, Filter, and Sort options for that column.
Select Filter to create a basic filter condition like what is available via the Filter tool. The available filter operators vary based on the data type of the selected column.
Create your condition and select Apply. The Results window refreshes and shows only the data that matches the active filter condition. The column where the filter was applied is indicated with a vertical ellipsis icon.
To remove the filter, hover over the filtered column and select the vertical ellipses icon. Select Filter and select the Clear link. The Results window refreshes to show data without the filter.
To create a custom or advanced filter condition, use and configure a Filter tool in your workflow.
Add Filter Tool to Workflow
When you filter a column in the Results window, you have the option to apply that filter as a Filter tool in the workflow. Read the Apply Data Manipulations section below for instructions.
Sort
The Results window also gives you access to sorting options that are otherwise available via the Sort tool. To sort a specific column in your Results window...
Hover your mouse over a column header and select the vertical ellipsis icon to access the Data Cleanse, Filter, and Sort options for that column.
Select Sort.
Select one of these sorting options and select Apply.
Don't Sort: Default option.
Sort Ascending
Sort Descending
To remove the sort, select the Don't Sort option.
Add Sort Tool to Workflow
When you sort a column in the Results window, you have the option to apply that action as a Sort tool in the workflow. Read the Apply Data Manipulations section below for instructions.
Apply Data Manipulations
After you perform a data cleanse function, apply a filter to a column, or sort a column in the Results window, you have the option to apply those changes to your workflow via associated tools. For example, if you applied a filter to a column in your Results window, you can add a preconfigured Filter tool to your workflow with the click of a button.
To add tools to your workflow, select the Apply Data Manipulations icon (checkmark).
Data Cleanse: When you perform a data cleanse action on a column, select Apply Data Manipulations. This adds a Data Cleansing tool to your workflow with the data cleanse function that you applied in the Results window.
Filter: When you filter a column in the Results window, select Apply Data Manipulations. This adds a Filter tool to your workflow with the filter condition that you applied in the Results window.
Sort: When you sort a column in the Results window, select Apply Data Manipulations. This adds a Sort tool to your workflow with the sort condition that you applied in the Results window.
To revert any changes that you have made to the Results table (you can only do this before you apply data manipulations), select the Cancel Data Manipulations icon.
Notes
The Apply and Cancel Data Manipulations icons are only usable in the Data view of the Results table. They activate when you make a change to the data (for example, sort a column) and select Apply. The icons are not active in the Metadata view of the Results table.