Optional Syntax Elements for Pack - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
lifecycle
latest
Product Category
Teradata Vantage™
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 Teradata Vantage™ - SQL Fundamentals, B035-1141.
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