The Unpack 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 is complementary to the function Pack, but you can use it on any packed column that meets the input requirements.