Unpack_MLE Function | Teradata Vantage - Unpack_MLE (ML Engine) - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

The Unpack_MLE function unpacks data from a single packed column into multiple columns. The packed column is composed of multiple virtual columns, which become the output columns. To determine the virtual columns, the function must have either the delimiter that separates them in the packed column or their lengths.

Unpack_MLE complements the function Pack_MLE (ML Engine), but you can use it on any packed column that meets the input requirements.

To use Pack_MLE and Unpack_MLE together, you must run both on ML Engine platform. Pack_MLE and Unpack_MLE are incompatible with Advanced SQL Engine Pack and Unpack functions.