I have a list of account IDs. I also have lists of contacts with relative Account IDs. How do I filter the contact lists to only contain contacts that have account IDs that exist on the separate list?
You can use Clay's filtering functionality to accomplish this: 1. Click "Filter" above your table
2. Select the Account ID column you want to filter
3. Choose "equal to" or "contains" as the operator
4. Enter the Account ID value you want to matchFor multiple Account IDs, you can add additional filters by clicking the "+" button and repeating the process with different Account ID values.
Source:Hide, Re-order, Sort, Filter, Merge Columns
Yes, you can use comma-separated values in the filter. When using the Filter List of Objects function: 1. Select the Account ID column as your "Filter Field"
2. Choose "Contains Any Of" as your Filter Mode
3. Enter your Account IDs as comma-separated values in the "Value(s)" fieldThe filter will match any records where the Account ID matches any of the values in your comma-separated list.
Sources:Filter List of Objects with ClayComparison operators | Clay University