Question

How to extract every 100th row in looker

  • 12 October 2021
  • 1 reply
  • 14 views

Do you know, how to extract every 100th or nth row in looker?


1 reply

Userlevel 6
Badge +1

Considering the fact that 100th row might be different depending on your Looker joins, you would need the n-th to be a column in your source data.. Alternatively, you can try to add a dimension with a window function but I haven’t tested it myself..

Reply