Hi all, I’m new to KNIME, but I have worked with other ETL tools before.
The weird thing I experience issues with here is the IF statement, the most basic thing. Nowhere can i find a proper example how to do it, only very specific example that did not work for me.
My current example looks like this:
IF $Genre$ is null THEN $Subgenre$
ELSEIF $Genre$ is null AND $Subgenre$ is null THEN “Unknown”
ELSE “Unknown”
Basically replacing nulls in a column with values from another one.
@Gavin_Attard yes, I think so. TRUE is the default outcome, which I would interpret as being the equivalent to ELSE in programming languages (but hey, I’m not a developer by any means )