PHP ETL
  • Introduction
  • Getting Started
  • Extractors
    • Collection
    • CSV
    • Fixed Width
    • JSON
    • Query
    • Table
    • XML
  • Transformers
    • Convert Case
    • JSON Decode
    • JSON Encode
    • Rename Columns
    • Trim
    • Unique Rows
  • Loaders
    • Insert
    • Insert/Update
  • Helpers
  • Running Processes
Powered by GitBook
On this page
  • Skipping initial lines
  • Limiting the output rows

Helpers

Besides the three common steps in an ETL process (extract, transform and load), we provide some helpers to assist you with the process data flow.

Skipping initial lines

To skip a determined number of rows on the beginning of the process, you may use the skip method, passing the number of rows to skip as a parameter:

$etl->skip(1);

Limiting the output rows

To limit the maximum number of output rows of the process, you may use the limit method, passing the maximum number of rows as a parameter:

$etl->limit(100);
PreviousInsert/UpdateNextRunning Processes

Last updated 6 years ago