Optional Syntax Elements for Pack - Teradata VantageCloud Lake
Lake - Analyze Your Data with ClearScape Analytics™
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata VantageCloud Lake
- Release Number
- Published
- February 2025
- ft:locale
- en-US
- ft:lastEdition
- 2026-02-20
- dita:mapPath
- tcl1683670667798.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- tcl1683670667798
- TargetColumns
- Specify the names of the input table columns to pack into a single output column. Column names must be valid object names, which are defined in SQL Fundamentals.
- These names become the column names of the virtual columns. If you specify this syntax element, but do not specify all input table columns, the function copies the unspecified input table columns to the output table.
- Default behavior: All input table columns are packed into a single output column.
- Delimiter
- Specify the delimiter, a single Unicode character in Normalization Form C (NFC), that separates the virtual columns in the packed data. The delimiter is case-sensitive.
- Default: ',' (comma)
- IncludeColumnName
- Specify whether to label each virtual column value with its column name (making the virtual column target_column:value).
- Default: 'true'
- Accumulate
- Specify the input columns to copy to the output table.
- ColCast
- Specify whether to cast each numeric target_column to VARCHAR.
- Specifying 'true' decreases run time for queries with numeric target columns.
- Default: false