I’m coming from a Tableau background where it’s very straight forward.
IF [CourseCode] = ‘8021’
OR [CourseCode] = ‘8022’
OR [CourseCode] = ‘TRWSH’
OR [CourseCode] = ‘RSWSH’
THEN ‘Yes’ ELSE ‘No’ END
I’m trying to create something like this, what I have found is that I might be utilizing the Rule Engine node. Is this correct? How might I go about this if so?
One more to add on here. I have another field that is a bit more complex than the previous.
IF {FIXED [SSID]: MAX([CourseCode] = ‘8022M’)}
AND {FIXED [SSID]: MAX([Entity Id] = ‘439’ OR [Entity Id] = ‘442’)}
THEN ‘Yes’ ELSE ‘No’ END
This is looking at that specific class, but also only at 439 and 442 entity. I have others based on this, but having this solved will help me with the others.
Figured it out already, Knime is always looking at row level detail it seems. Where as Tableau you have to tell it you want to look at the row as a whole, hence the FIXED function. So just putting the course code AND entity worked.