Unpack Function Example | Teradata Vantage - Example: Input Columns with Trailing Special Characters - Analytics Database

In this example, the items in the first virtual input column have trailing special characters. No delimiter separates the virtual columns. ColumnLength is 2. The call to Unpack includes IgnoreInvalid ('true'), but the output is unexpected.

Unpack Input

Unpack SQL Call with IgnoreInvalid ('true') with Trailing Special Characters

SELECT * FROM Unpack (
  ON t2 AS InputTable
  USING
  TargetColumn ('c1')
  OutputColumns ('a','b')
  OutputDataTypes ('int','date')
  ColumnLength ('2','*')
  IgnoreInvalid ('True')
) AS dt;

Unpack Output with IgnoreInvalid ('true') with Trailing Special Characters

The reason for the unexpected output is the behavior of an internal library that Unpack uses, which is as follows: