"Equals any of" in advanced table filter

[s0nial]

Hi there, 

I'm trying to filter a table based on a selection of different product numbers. I tried creating a segment using the 'equals any of operator', but the table returns additional products because there is often more than 1 product on a single analytics call. 

Instead, I'm trying to filter the table manually using the advanced filter, but there is no 'equals any of' operator. 

When I use this search filter, it will also return products that contain that number: eg: if I filtered for DM_73016, it also brings DM_730166 too for example.

Are there any ways around this? I need to filter by 300 different product keys, so manually adding each isn't an option

Thank you! 

Sonia

[VaniBhemarasetty]

@s0nial Does Product dimension that you are using is having more 500,000 unique values in a month ? If that is the case, there is a high possibility of hash collision that can happen

You can read about more here

https://experienceleague.adobe.com/docs/analytics/implementation/validate/hash-collisions.html?lang=...

[Jennifer_Dungan · Accepted solution]

Unfortunately, Products is a real pain to work with.. you are correct that with multiple products on a single call, more than what you are looking for will be returned with the segment.

Also, it's not a hash collision.. since you are using "contains any term" and "DM_73016" is clearly part of "DM_730166"...I've experienced hash collisions in our own data, and it's definitely not fun.

If you were trying to return a smaller set of data, you could have added an extra "doesn't contain clause", but this just isn't realistic in your scenario.

Sadly, I think your only option is to get the data external to Adobe (either using Data Warehouse or Report Builder) and use Excel to parse the data and return only the values you want.