- class atoti.MultiColumnArrayConversion#
Convert an external table where the array values are stored with one element per column to a table with arrays.
When a table has at least 2 columns with names following the pattern
prefix + delimiter + number(numbers being consecutive and starting with 0 or 1), all these columns can be converted into a single array column.
For instance, given a table where a “Quantity” array is stored with 5 five columns:
These columns can be matched with the
"QUANTITY"prefix and it will be converted to a table with an array column:
If several prefixes are passed, a distinct array column will be created for each of them.