Optional Syntax Elements for TD_CFilter - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-01
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

The following elements are optional when using TD_CFilter.

PartitionColumns
Specify the names of the input columns to copy to the output table. The function partitions the input data and the output table on these columns.

Maximum 10 columns are allowed.

PartitionColumns makes TD_CFilter output nondeterministic unless each partition_column is unique in the group defined by TransactionIDColumns.
MaxDistinctItems
Specify the maximum size of the item set.

Default: 100