Search
Search operations and explore column values.
Overview
ExploreMyData has three search contexts that help you find what you need quickly: the global search box in the header for finding rows, the operation picker search for finding operations, and the Column Explorer search for filtering values within a column. The global box matches your term against every column in the current view, numbers and dates included, and filters the grid to the rows that contain it.
Operation Picker Search
Click the + button in the pipeline sidebar to open the operation picker. A search box appears at the top. Start typing to find operations instantly. The sidebar also has a Search transforms box that shows matching operations inline, without opening the picker.
What Gets Searched
The operation picker uses fuzzy matching across multiple fields:
- Operation name - e.g., "Filter", "Join", "Add Column".
- Description - e.g., "Show only rows matching conditions".
- Keywords - related terms that help surface the right operation.
Search Examples
| You Type | Operations Found |
|---|---|
filter | Filter |
remove | Remove Duplicates, Filter, Delete Columns |
math | Math, Add Column |
date | Extract Date Part, Increment Date, Date Difference |
min | Smallest |
text | Text Transform, Find & Replace, Extract Text |
Fuzzy matching means you do not need an exact match. Typing "dup" will find "Remove Duplicates", and "col" will surface column-related operations.
Column Explorer Search
When you open a categorical column in the Column Explorer, the card shows a list of unique values with their counts. If the column has many unique values, use the search box at the top of the card to filter the value list.
- Type a partial value to narrow down the list.
- Matching is case-insensitive.
- Click any value in the filtered list to create a filter for it.
Tips
- Use short, descriptive terms in the operation picker - one or two words is usually enough.
- If you are not sure which operation to use, try searching by what you want to do (e.g., "merge", "clean", "split").
- The Column Explorer search is especially useful for columns with hundreds of unique values, like product names or customer IDs.