_Transform tip

You can use 'transform' to:

• create a new column containing a simple calculation
• join columns, or
• duplicate columns.

There are some special ‘transforms’ that help with classifying and categorising by entering a formula (similar to an Excel formula). 

Access transform from the green plus that appears after you add a data stream. See Transform a column in Designer