Rule Engine Node concatenation

[Vincentsoy]

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.

Thanks a lot in advance!

[elsamuel]

"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?

[mlauber71]

@Vincentsoy if you like more complicated conditions you can always use the Java snippet and just write them the way you like.

It’s just a little bit more setup and not so ‘KNIME like’ but does work perfectly well.

java snipped simple if else

I built this example from the previous one where you could use a combination of columns and Flow Variable in a simple Java Snippet. It might serve as another inspiration. [image] The code is like this: // make the incoming Flow Variable into a Java variable double v_input_factor; v_input_factor = $${Dinput_factor}$$; // convert the double Java variable into a string to use in the code // https://www.journaldev.com/18380/java-convert-double-to-string String v_input_factor_string = new Stri…

If it is just one condition also the simple Java Snippet might work:

Use Java Snippet to set rule for certain Row ID - also demonstrating the use...

If you still want more Java I have this collection:

Meta Collection about KNIME and Java – mlauber71