Filtering rows with multiple words criteria
Hey Guys.
Sorry if I open a new thread but I didn’t find a solution to my problem in the old ones.
I’m trying to filter rows that contain in a specific column certain words. For example:
Lumaca, bergamoto, equiseto, etc.
The column contains sentences and the words I need to filter can be in different parts of the sentence (at the end or the beginning).
I tried to use the following rule in a ruled-base row filter node with no success:
$DESCRIZIONE ARTICOLO$ LIKE “Bergamotto” => TRUE
$DESCRIZIONE ARTICOLO$ LIKE “Equiseto” => TRUE
$DESCRIZIONE ARTICOLO$ LIKE “Lumaca” => TRUE
The workflow always returned a blank table. When I tried to substitute " with * then the syntax was wrong.
Can you guys help me?
Best Regards,
Giammarco