User GuidesAPI ReferenceRelease Notes
Doc HomeHelp CenterLog In

Using Fill, Formula, MultiFormula, and Unpivot

Tamr provides streamlined and efficient alternatives to scripts through these options.

When you use the transformation panel to add a transformation, the transformation editor that opens offers the following options:

994

The options available when you add a transformation.

Scripts can use all types of statements, including SELECT, GROUP BY, and JOIN. These statements can include multiple expressions. See Writing Transformation Scripts.

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.