Browse documentation

#Offset

The offset operation skips a specified number of rows from the beginning of the dataset, commonly used for pagination and data sampling.

#Basic Offset Usage

#offset() - Skip rows from beginning

<?php

use function Flow\ETL\DSL\{data_frame, from_array, to_output};

$dataFrame = data_frame()
    ->read(from_array([
        ['id' => 1, 'name' => 'Alice'],
        ['id' => 2, 'name' => 'Bob'],
        ['id' => 3, 'name' => 'Charlie'],
        ['id' => 4, 'name' => 'David'],
        ['id' => 5, 'name' => 'Eve'],
    ]))
    ->offset(2) // Skip first 2 rows
    ->write(to_output())
    ->run();

// Output: Charlie, David, Eve

#Performance Considerations

⚠️ Performance Warning: The offset() method must iterate through and process all skipped rows to reach the offset position. For large offsets (e.g., offset(1000000)), this can significantly impact performance as the DataFrame still needs to read and process all data up to the offset point.

Found a typo or an outdated section? Edit this page on GitHub ↗