Unpack Function Example | Teradata Vantage - Example: No Delimiter Separates Virtual Columns - Analytics Database

Unpack Input

The input table is ville_tempdata1 with no delimiter that separates the virtual columns in the packed data. To enable the function to determine the virtual columns, the function call specifies the column lengths.

Unpack SQL Call with No Delimiter Separates Virtual Columns

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

Unpack Output with No Delimiter Separates Virtual Columns