Shape · Rows

Generate Rows

Repeats each row once per value of a range, such as 1 to a count column or a start date to an end date, and adds the generated value as a column. For a sequence with no input, use Generate Series.

Also known as: Expand rows, one row per day, repeat rows

How it works

Kind is Integer, Date or Timestamp. Start, End and Step are each a fixed Value or a Column of the row; a fresh node starts at 1, steps by 1 and takes End from a column. Include end, on by default, keeps the end value in the range. Every input row is repeated once per value, keeping its other columns, and the value lands in Output column, Generated Row by default; a name that already exists keeps the input column and the new one becomes <name>_1. A date step is an interval such as 1 day or 1 month. A row whose bound is NULL, or whose step column is 0, produces no rows and is counted in a warning. For a sequence with no input use Generate Series.

Inputs and outputs

Settings

{
  kind: "integer" | "date" | "timestamp"
  start: {mode:"constant"|"column", value}
  end: {mode, value}
  step: {mode, value}
  includeEnd: boolean
  outputColumn?: string
}

Example

One row per night of each hotel booking: Kind Date, Start Column check_in, End Column check_out, Step Value 1 day, Include end off, Output column night.

More in Rows

• Filter — Keeps only the rows that meet your conditions, combined with AND or OR. For example, keep orders where the amount is over 100.
• Switch — Sends each row down one of several outputs: it goes to the first case whose condition is true, and rows that match none go to Default.
• Sort — Puts rows in order by one or more columns, ascending or descending, with blanks first or last.
• Row Limit — Keeps or drops the first or last N rows, in their current order. For example, skip three header lines or take 100 rows for a quick check.
• Top / Bottom N — Keeps the N rows with the largest or smallest values in one column, such as the 10 best-selling products. You choose what happens to ties at the cut-off.
• Distinct — Keeps one row per unique combination of key columns. You choose whether the first or last copy survives; with no keys it drops exact duplicate rows.
• Random Sample — Picks a random set of rows, either a fixed number or a share such as 10%. You can sample with replacement, or stratify by a column so each group keeps its share. Set a seed to get the same rows every time.
• Random Split — Divides rows into named groups by percentage, each on its own output, such as 80/20 train and test. Repeatable, and can keep each group's share of a column.
• Add Row Number — Numbers the rows 1, 2, 3… in a new column. You can sort first and restart the count in each group.
• Rank — Ranks rows by one or more columns, optionally within groups, so the top seller per region gets 1. You choose how ties are ranked; percentile rank is available too, and Tile splits the rows into N equal-sized buckets.
• Densify — Adds the rows that are missing so every key combination appears, taken from the data or from a reference table you wire in, and fills the gaps with values you choose. For example, every product for every month, with 0 sales where none were recorded.