Extracts
Read from various data sources.
Transforms
Shape and optimize for your needs.
Loads
Store and secure in one of many available data sinks.
Examples:
Code
<?php
declare(strict_types=1);
use function Flow\ETL\DSL\{array_entry,
array_expand,
data_frame,
from_rows,
int_entry,
ref,
row,
rows,
to_stream};
require __DIR__ . '/../../../autoload.php';
data_frame()
->read(from_rows(rows(
row(int_entry('id', 1), array_entry('array', ['a' => 1, 'b' => 2, 'c' => 3])),
)))
->withEntry('expanded', array_expand(ref('array')))
->write(to_stream(__DIR__ . '/output.txt', truncate: false))
->run();
Output
+----+---------------------+----------+
| id | array | expanded |
+----+---------------------+----------+
| 1 | {"a":1,"b":2,"c":3} | 1 |
| 1 | {"a":1,"b":2,"c":3} | 2 |
| 1 | {"a":1,"b":2,"c":3} | 3 |
+----+---------------------+----------+
3 rows