Operations to standardize data include, for example, converting string and date & times values to follow the same style, normalizing numbers, and generating new features.
When applying data transformation operations, there are a few very versatile nodes which probably cover all the operations you need: the String Manipulation node, the Math Formula node, and the Rule Engine node.
The workflow used in this video is available on the KNIME EXAMPLES server under 02_ETL_Data_Manipulation/04_Transformation/02_StringManipulation_MathFormula_RuleEngine
Access the workflow "String Manipulation, Math Formula and Rule Engine Example" from the KNIME Community Workflow Hub: https://hub.knime.com/knime/workflows...
To know more about Data Manipulation in KNIME Analytics Platform check Chapter 3 of the Introductiory Course to Data Science with KNIME https://www.knime.com/knime-introduct...