Supabind

Filter Data

Quickly locate and process specific records. Search, filter, sort, and clean up your table without leaving the transformation workspace.

Quick Navigation

• Search Records• Apply Filters• Sort Data• Remove Duplicate Records• Filter Empty Values

Overview

Once a table is open in the transformation workspace, you can narrow it down to exactly the records you need. Use the search bar for a quick lookup, or open Filters in the toolbar to build conditions, sort columns, remove duplicate rows, or exclude records with missing values. Every change updates the Data Preview and the row count immediately.

Search Records

Use Search data to quickly locate rows containing a specific value, without setting up a filter condition.

Search data...
Matching rows appear instantly in the Data Preview as you type, and the row count updates to reflect the results.

Steps

  1. Open a table in the transformation workspace.
  2. Click the Search data field above the table.
  3. Type the value, keyword, or number you're looking for.
  4. Review the matching rows in the Data Preview and the updated row count.
  5. Clear the search field to return to the full table.

Apply Filters

Filters let you narrow a table down to rows that meet one or more conditions-for example, a column that equals a value, is above a number, or contains specific text.

Filters

Add Filter
brandequalsNike
Add multiple conditions and combine them to match all or any of the rules you set.

Steps

  1. Click Filters in the toolbar.
  2. Click Add Filter and choose the column you want to filter on.
  3. Select a condition, such as equals, contains, greater than, or is empty.
  4. Enter the value to filter by, if the condition requires one.
  5. Add more conditions if needed, then apply the filter to update the Data Preview.

Filters apply to the active table only and can be combined with search and sorting. Remove a condition at any time to widen the results again.

Sort Data

Sort a table by one or more columns to bring the records you care about to the top, ascending or descending.

Steps

  1. Open a table in the transformation workspace.
  2. Click the column header you want to sort by.
  3. Select ascending or descending order from the sort option.
  4. Sort by an additional column if you need a secondary sort order.
  5. Review the reordered rows in the Data Preview.

Remove Duplicate Records

Remove rows that repeat the same values, based on one column or a combination of columns, to keep only unique records in your table.

Steps

  1. Click Filters in the toolbar.
  2. Choose Remove Duplicates.
  3. Select the column, or combination of columns, used to identify duplicate rows.
  4. Apply the change to remove the duplicate rows.
  5. Review the updated row count in the Data Preview to confirm how many rows were removed.

Removing duplicates changes the working table directly. Double-check the columns you choose before applying, since the removed rows aren't restored automatically.

Filter Empty Values

Find rows with missing data, or exclude them, to clean up a table before exporting or syncing it downstream.

Steps

  1. Click Filters in the toolbar.
  2. Click Add Filter and choose the column you want to check.
  3. Select the condition is empty to find missing values, or is not empty to exclude them.
  4. Apply the filter to update the Data Preview.
  5. Repeat for additional columns if you need to check more than one field.

Was this article helpful?

Need More Help?

If you need assistance searching, filtering, sorting, or cleaning up records in your datasets, our support team is here to help.

Contact Support