When you use the transformation panel to add a transformation, the transformation editor that opens offers the following options:
While the Script option offers a flexible, fully featured utility for writing SQL-like scripts, the other options provide ways to transform data by using a more structured interface.
- Fill provides an interface for a single SELECT statement in which the expression is always a string literal.
- Formula provides an interface for a SELECT statement with a single expression.
- MultiFormula provides an interface for applying the same expression to one or more columns.
- Unpivot provides a template for a simplified UNPIVOT statement. If you choose this Unpivot option, it can only act on the columns of your dataset. In order to write a more complex unpivot, you must use the UNPIVOT statement within a script, where you can apply the unpivot to more complex expressions (such as including functions) and literals.
Updated almost 2 years ago