Data Transformation in KNIME
Mahantesh Pattadkal
Sr. Data Scientist
IF
StatementSyntax
IF(condition_1, value_1, additional_conditions, value_if_all_false)
Operators are used to compare column values to
Add "Age group" column
Syntax:
IF($Age$>18,"Adult","Non-Adult")
Output:
AND
Returns True if all the conditions are met
OR
Returns True if any of the conditions are met
NOT
Returns the negation of boolean expression
Assign the tag as a weekend
Syntax
IF($Day$="Saturday" OR $Day$="Sunday", "Weekend", "Weekday")
Orders data from KIA - Online furniture shopping company
Data Transformation in KNIME