Pack Function Example | Teradata Vantage - Example: Nondefault Options - Analytics Database

This example specifies the pipe character (|) for Delimiter and 'false' for IncludeColumnName.

Pack with Nondefault Options SQL Call

SELECT * FROM Pack (
  ON ville_temperature
  USING
  Delimiter ('|')
  OutputColumn ('packed_data')
  IncludeColumnName ('false')
  TargetColumns ('city', 'state', 'period', 'temp_f')
) AS dt ORDER BY 2;

Pack with Nondefault Options Output

Virtual columns are separated by pipe characters and not labeled with their column names.