Unpack Function Example | Teradata Vantage - Example: More Input Columns than Output Columns - Analytics Database

Unpack Input

The input table is ville_tempdata1 with no delimiter that separates virtual columns in the packed data. Its packed_temp_data column has three virtual columns.

Unpack SQL Call with More Input Columns than Output Columns

The OutputColumns syntax element specifies only two output column names.

SELECT * FROM Unpack (
  ON ville_tempdata1 AS InputTable
  USING
  TargetColumn ('packed_temp_data')
  OutputColumns ('city', 'state')
  OutputDataTypes ('varchar', 'varchar')
  ColumnLength ('9', '9') 
  Regex ('(.*)')
  RegexSet (1)
  IgnoreInvalid ('true')
) AS dt ORDER BY sn;

Unpack Output with More Input Columns than Output Columns

The output table has columns for the first two virtual input columns, but not for the third.