Hi Clay team, I am trying to apply a "Not empty" filter on the "Landing Page Content" column for some Selected Rows in this table, but the table turns empty when I do this. How can I resolve this issue?
Hi Syed, thanks for reaching out. Do you mind sending the link to the table so we can take a look? The issue here may be that for that specific column there are in fact no empty cells so the filter removes all rows accordingly. https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1730906100&signature=9a7573ed7a32c38f2e077424dc9a0073279126fc6cd2f497a5f8519a9d87554e&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSv1BpEX2BKsam%2FhVPum%2Fw%3D%3D%0A
Check out this view I created: https://app.clay.com/workspaces/318074/tables/t_NR2eheND7e6G/views/gv_s2o3onqabApb All I did here was adding a filter rule where I'm filtering out the instances in which the landing page content is empty: https://downloads.intercomcdn.com/i/o/w28k1kwz/1241930158/8f178f2a74bebb359285c18222fc/CleanShot+2024-11-06+at+10_05_50%402x.png?expires=1730907000&signature=6352a95d600de1b75c68651dfb2a5784f029ee63f7baf4fb4633736c30b7fe3d&req=dSIjF8B9nYBaUfMW1HO4zYcYmIAIShMJUXT4rKBHmBlIjPayJ%2B7%2B31YthltS%0Af2Qc%0A You can see that this is functioning as expected here: https://downloads.intercomcdn.com/i/o/w28k1kwz/1241930949/de538bf19408bc4729bbf9062169/CleanShot%2B2024-11-06%2Bat%2B10_06_48-402x.png?expires=1730907000&signature=5c8c9f374da366ad7ab5acb67fe1319e38250cc04071ba2b891436af4a548458&req=dSIjF8B9nYhbUPMW1HO4zQnS%2BRqQNarDOAJH6q7wZaA2ZPBDsKxvc6BlvfIJ%0ArcAL%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!
No, I need to run for just these rows. When I apply the filter for these selected rows, the table becomes empty.
To clarify, you want to run an enrichment only for rows where the landing page content is not empty, correct? If so, you'll need to create a view that filters out the rows with empty values—similar to the Clay support view I shared earlier. Once you've set up this filtered view, you can configure the enrichment to run specifically for the rows within that view: https://downloads.intercomcdn.com/i/o/w28k1kwz/1241970930/06c64a2eaf15106cda472edf5340/CleanShot+2024-11-06+at+10_32_41%402x.png?expires=1730908800&signature=3c676a9170e8b0443c4b89ef4f1082f78fdab628858d4f462ad341f25763e343&req=dSIjF8B5nYhcWfMW1HO4zfvhvvh6F5Lg0u%2BhcGNBzoLwND5HMIOXV7CjaDQY%0Ac%2Bvq%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!
I don't want to run enrichment. I just want to apply filter. I have 1,600 rows in this table, and I've selected the last 500 rows, which I need. I want to apply a filter on the "Landing Page Content" column with the condition "Landing Page Content is Not empty." However, when I apply the filter on "Landing Page Content" column, the entire table turns empty, even though I have results in the "Landing Page Content" column for these 500 rows.
I see, thanks for your patience and for reporting this Syed. It looks like we've got a bug on our hands - I've escalated this over to our engineering team and we'll let you know as soon as we know more!
Ok. Thank You..
Hi Syed, we've noted this issue and added it to our product backlog. In the meantime, I suggest the following workaround: 1. Create a restricted view that displays only the last 500 rows of the table. 2. Export this view to a CSV file. 3. Import the CSV file into a separate table. 4. Filter the new table using the values you need. I understand this isn't the most optimal solution, but it should get the job done for now.