Tamr Documentation

Using Fill, Unpivot, and Formula

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

When you use the transformation editor to add a transformation, Tamr offers the following options:

The options available for adding a Tamr transformation.

The options available for adding a Tamr transformation.

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.

  • Scripts can use all types of statements, including SELECT, GROUP BY, and JOIN. These statements can include multiple expressions.
  • Formula provides an interface for a SELECT statement with a single expression.
  • Fill provides an interface for a single SELECT statement in which the expression is always a string literal.
  • 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 13 days ago



Using Fill, Unpivot, and Formula


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

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.