Search
Search operations and explore column values.
Overview
ExploreMyData has two search contexts that help you find what you need quickly: the operation picker search for finding operations, and the Column Explorer search for filtering values within a column.
Operation Picker Search
Click the + button in the toolbar to open the operation picker. A search box appears at the top. Start typing to find operations instantly.
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.