Clay Icon

How to Enter a Value in Filtered Rows Without Affecting Others

ยท
ยท

Hi Team, I would like to know how I can enter a single value into a specific column only into the filtered rows, without affecting unfiltered rows. When I try to use the "copy -> paste" function on a filtered dataset, it does not produce the expected result. Could you guide me on how to achieve this correctly and efficiently?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can use filtered views to selectively enrich and modify data for specific rows. Here's how to set up filters:For text columns:1. Click "Filter" above the table 2. Select your desired column 3. Choose from options like "equal to," "contains," "is empty," etc. 4. Enter your filter valueFor number columns:1. Click "Filter" above the table 2. Select your number column 3. Choose from options like "equal to," "greater than," "less than," etc. 4. Enter your numeric valueOnce filtered, any enrichments or modifications will only apply to the rows you're currently viewing. Sources: Guide: Ways to Save Clay Credits - Clay University Hide, Re-order, Sort, Filter, Merge Columns