Hi. I have some complex coding to do that seems best tackled using nested if-then statements. For example, if I am coding column A, the logic might look like this: IF X=1 OR X=2 OR X=3 THEN IF Y=1 or Y=2 THEN A=1 ELSE IF Y=3 OR Y=4 A=2 ELSE A=9 END IF ELSE IF X=4 IF Z=1 A=1 ELSE IF Z=2 OR Z=3 A=4 END IF END IF This is a simplified example, what I need to do will often go four nests deep. All of the variables I am dealing with are numeric. I know how to do this in Excel and SPSS, but not sure the best way in Knime. I have seen Java Snippet mentioned. Is this in fact my best bet? I am not too familiar with Java, but this is something I will need to be doing often, so if I need to spend some time learning it, I’ll do so. I’ve used Rule Engine a lot for simpler logic, but I do not see how to do nested logic in that environment… am I missing something? Thanks for any help!. EDIT: Looks like I need to figure out how to indent, I see my example is pretty hard to read. I’ll try to figure that out.

Best Node for nested if-then logic?

elsamuel June 8, 2020, 6:25pm 2

I think the Column Expressions, Rule Engine, and Java Snippet nodes will all be able to do this.

This thread has some tips

3 Likes