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


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).


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

See Also

Was this page helpful?
Yes No