Repeat the nth value of the the given column for every row in a column.

Usage

Nth(field, n)

field (required) Column to pick from.

n (required) Offset from top of column. Must be an integer greater than 0. The integer must also be constant (i.e. don't pass in columns with multiple distinct values).

Example

Nth([Quarter], 2)
  • If Quarter has”Q1″,”Q2″,”Q3″and”Q4″, the result would be”Q2″,”Q2″,”Q2″and”Q2″.

See Also