Pack Example 2: Nondefault Values - Teradata Vantage

Input

• Input table: ville_temperature, as in Pack Example 1: Default Values

SQL Call

Delimiter and IncludeColumnName have nondefault values.

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

Output

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