limit() function

The limit() function limits each output table to the first n records. The function produces one output table for each input table. Each output table contains the first n records after the offset. If the input table has less than offset + n records, limit() outputs all records after the offset. limit() is a selector function.

limit(n:10, offset: 0)

Parameters

n

(Required) Maximum number of records to output.

offset

Number of records to skip per table before limiting to n. Default is 0.

tables

Input data. Default is piped-forward data (<-).

Examples

The following examples use data provided by the sampledata package to show how limit() transforms data.

• Limit results to the first three rows in each table
• Limit results to the first three rows in each input table after the first two

Limit results to the first three rows in each table

import "sampledata"

sampledata.int()
    |> limit(n: 3)

Limit results to the first three rows in each input table after the first two

import "sampledata"

sampledata.int()
    |> limit(n: 3, offset: 2)