Documentation Index
Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
Use this file to discover all available pages before exploring further.
final class atoti.MultiRowArrayConversion
Convert an external table where array values are stored with one value per row to a table with array columns.
The external table must have an index_column and at least one “value” column representing the array elements.
All the table columns except from index_column and the array_columns will become key columns.
Example
>>> external_database = session.connect_to_external_database(connection_config)
>>> external_table = external_database.tables["TUTORIAL", "MULTI_ROW_QUANTITY"]
external_table has an INDEX column:
>>> list(external_table)
['PRODUCT', 'INDEX', 'QUANTITY']
| PRODUCT | INDEX | QUANTITY |
|---|
| product_1 | 0 | 10 |
| product_1 | 1 | 20 |
| product_1 | 2 | 15 |
| product_1 | 3 | 25 |
| product_1 | 4 | 10 |
| product_2 | 0 | 50 |
| product_2 | 1 | 65 |
| product_2 | 2 | 55 |
| product_2 | 3 | 30 |
| product_2 | 4 | 80 |
>>> table = session.add_external_table(
... external_table,
... config=TableConfig(
... array_conversion=tt.MultiRowArrayConversion(
... array_columns={"QUANTITY"},
... index_column="INDEX",
... ),
... ),
... table_name="Sales (Multi row array)",
... )
>>> table.head().sort_index()
QUANTITY
PRODUCT
product_1 [10.0, 20.0, 15.0, 25.0, 10.0]
product_2 [50.0, 65.0, 55.0, 30.0, 80.0]
array_columns : Set[str]
Names of the columns that contain array values.
index_column : str
Name of the column used as an index for the arrays.
