Example:
ACHOCOLATADO EM PÓ LATA
$column1$ MATCHES “.ACHOCOLATADO.” => “Categoria”
$column1$ MATCHES “.LATA.” => “Pote”
But I would like to make a condition where “LATA” and “ACHOCOLATADO” are “Pote”
Sorry for the simple question. Should I keep using Rule Engine?
if for above example you want to have only one output and that output to be “Pote” then switch rules in Rule Engine as “The first matching rule in order of definition determines the outcome.”. If you want something else you should explain it a bit more.
From experience it’s best if you share some data input and expected output. Dummy data works just fine. This way we avoid guessing and you get suggestions and/or solutions sooner.
Hi @ipazin, sorry for not being clear and thanks in advance for your answer.
For example, if i have these three descriptions, I would like to have these outputs:
ACHOCOLATADO EM PÓ LATA => “Pote”
ACHOCOLATADO EM PÓ SACHE => “Sache”
ACHOC EM PÓ LATA => “Pote”
$column1$ MATCHES “.ACHOCOLATADO. ” => “Categoria”
$column1$ MATCHES “.LATA. ” => “Pote”
$column1$ MATCHES “.SACHE. ” => “Sache”
I would need a way to put it as “Pote” if they encounter “ACHOCOLATADO” and “LATA” in the same description but at the same time, if I only have “ACHOCOLATADO SACHE”, I need to return “Sache”
your logic is still not exactly clear to me but replacing first and second rule might do the trick because of reasons mentioned in previous post. Also I recommend to use operator LIKE instead of MATCHES as latter is for regular expressions which is not needed here seems.