ToList / Array Layer

Convert fixed-length arrays to variable-length lists. Similar to converting numpy fixed arrays to Python lists. Maintains values while removing length constraints.

Example transformation (arrays of length 3):

arrays (fixed-len)	lists (variable-len)
[1, 2, 3]	[1, 2, 3]
[x, y, z]	[x, y, z]
[true, false, true]	[true, false, true]
[4, 5, 6]	[4, 5, 6]

Common applications:

Converting fixed arrays to flexible lists
Preparing for variable-length operations
Removing length constraints
Data structure conversion

Note: Content and order are preserved. The underlying type changes from fixed-length array to variable-length list. Input arrays must have the same fixed length across all rows.

Table

Select

column

The fixed-length array column to convert. Supports arrays of any type:

Numeric arrays: [1, 2, 3]
String arrays: [x, y, z]
Boolean arrays: [true, false, true]
Date/time arrays: [2024-01-01, 2024-01-02, 2024-01-03] All arrays must have the same length

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.