How to filter a text aggregator string data

How To
1

Hello, first of all, I would like to congratulate this great community. The help you provide here is incredible. I hope you can help me too.

I have used a Text Aggregator and I want to filter the result with a text condition, whether it contains or does not contain something, but it does not filter the way I expect it to.

Could you help me? I cannot share the downloaded files because they contain sensitive information.

Thank you in advance.

filtr3
filtr31096×819 92.7 KB

fil4
fil41078×1020 110 KB

2

Hi Magnus_Maker, the filter that you have there is looking for a text that meets both requirements Contain Mes1 and Does not contains Mes2, otherwise it won’t pass. If you want to filter out a text that meets one of the two requirements, you should use the OR rule. Delete the second filter and add Add OR rule, then add the requirements that you have in the second filter

3

Thanks @Jonathan_Escobar for the reply i will try but in fact i need to filter bouth conditions. Is it posible?

Ex.
The scenario its about payments and i would like to know the user with a pay in month1 but didnt pay the next month.

Thanks in advance.

4

If you want to filter a text that meets both conditions, then the AND operator is fine. What problem are you having?

5

The text aggregator output is:
Enero 2025 Febrero 2025 Marzo 2025
Key: User name

Filter:

contains Mes1 (Enero 2025)
and
Do not contains Mes2 (Junio 2025)

The filter output is the “key” Value for those user that met the filter but im getting users that has bouth payments: Mes1 and Mes2