Hello guys,
i have a Problem with the definition of a Rule in Rule Engine Node:
The spoken Rule would be:
"If the columns “Produkt”; “Stärke”; “Packung” and “DAFO” contain the same values that are included within the column “Konzern” = “Bayer” => write “Portfolio”
If NOT => write “Other” "
So at the end i can put a row filter that only shows the Row’s with “Portfolio” in it.
I’m very familiar with the IF-function in Excel but the Rule engine node is a bit more complicated when you want to concatinate different rules for different columns.
"If the columns “Produkt”; “Stärke”; “Packung” and “DAFO” contain the same values that are included within the column “Konzern” = “Bayer” => write “Portfolio”
I don’t really understand that rule. I also don’t see where concatenation comes into play.
Can you upload the data (and workflow) that you have so far?