Returns the first "n" number of elements derived from the given list based on the given number of items to return.

Syntax & Usage

Head([List], number of elements)
  • Create a list from which you want to derive the subset of elements.
  • Connect the "First" block to the list and enter a fixed value or parameter from the Insert Arguments window, to determine the number of elements to return.
  • Select "Exclude from Result Set" if you want to remove the first "n" elements from the list (as opposed to creating a list from them).


Here the first 20 elements are returned from the Product hierarchy: