Results Window Data Manipulations

Version:
2021.3
Last modified: August 11, 2021

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.

Image showing the Designer Results window with the Data Cleanse, Filter, and Sort options highlighted.

    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...

    1. Hover your mouse over a column header and select the vertical ellipsis icon to access the Data CleanseFilter, and Sort options for the column.
    2. 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
    3. 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...

    1. Hover your mouse over a column header and select the vertical ellipsis icon to access the Data CleanseFilter, and Sort options for that column.
    2. 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.
    3. 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.
    4. 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...

    1. Hover your mouse over a column header and select the vertical ellipsis icon to access the Data CleanseFilter, and Sort options for that column.
    2. Select Sort.
    3. Select one of these sorting options and select Apply.
      • Don't Sort: Default option.
      • Sort Ascending
      • Sort Descending
    4. 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.

    Image showing the Apply and Cancel Data Modifications icons highlighted in the Results window.

     

    1. 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.
    2. 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.
    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.