Page tree

Trifacta Dataprep



Contents:

If you licensed Dataprep by Trifacta before Oct. 14, 2020, you are using the Dataprep by Trifacta Legacy product edition. On October 14, 2022, this product edition will be decommissioned by Google and will be no longer available for use. Current customers of this product edition are encouraged to transition to one of the product editions hosted by Alteryx. See Product Editions.

   

You can search and replace for specific values in a column.

If the column is known

Steps:

  1. Select the column containing the value you wish to replace.
  2. In the Selection Details panel on the right side, click the appropriate bar under Unique Values. All matching values are selected within the column.
  3. Right-click the bar and select Replace Values....
  4. A pre-configured transformation appears in the Transform Builder. Example:

    Transformation Name Replace cells
    Parameter: Column myDates
    Parameter: Find '2013/02/07'
    Parameter: Replace with ''


    Tip: You can search for multiple items within the same column. Add other search values in additional Find textboxes.

  5. Add your value in the Replace with textbox.

  6. Click Add.
  7. All matching cell values in the column are replaced with your entered value. 

For more information, see Selection Details Panel.

If the column is unknown

Steps:

  1. If you do not know the column, click the Filter tool in the Transformer bar. 
  2. Click the Rows tab and enter the value to locate. Only rows where the value appears are displayed in the data grid. Each instance of the matching value is highlighted. 
  3. Locate the column containing the specific highlighted values to replace. Select the value.
  4. In the Suggestions panel, locate the Replace transformation card.
  5. Select the variant of the Replace transformation that contains the specific value you selected. Then, click Edit.
  6. A pre-configured transformation appears in the Transform Builder. Example:

    Transformation Name Replace text or patterns
    Parameter: Column myString
    Parameter: Find 'Red'
    Parameter: Replace ''
  7. Enter your replacement value in the Replace with textbox. 
  8. Click Add.
  9. All matching values in the column are replaced with your entered value. 

For more information, see Filter Panel.

See Also for Replace Cell Values:

There is no content with the specified labels

This page has no comments.