Examples

Transformations

Description

unpack() spreads an array column into named columns, using the schema given to describe the shape.

Documentation

Transformations are expressions over a row, evaluated column by column.

Transformations

Code

<?php

declare(strict_types=1);

use function Flow\ETL\DSL\{data_frame, from_array, int_schema, json_schema, ref, schema, to_output};

require __DIR__ . '/vendor/autoload.php';

data_frame()
    ->read(from_array(
        [
            ['id' => 1, 'array' => ['a' => 1, 'b' => 2, 'c' => 3]],
            ['id' => 2, 'array' => ['d' => 4, 'e' => 5, 'f' => 6]],
        ],
        schema(int_schema('id'), json_schema('array')),
    ))
    ->withEntry('unpacked', ref('array')->unpack(schema(
        int_schema('a'),
        int_schema('b'),
        int_schema('c'),
    )))
    ->write(to_output(truncate: false))
    ->run();

Contributors

Built in the open.

Join us on GitHub