Skip to content
Adaptam Docs

WRITE_H

Used to create horizontal headings from data fields.

WRITE_H function overview

Function syntax

WRITE_H(field1, ... | filter1, ... | option1, ...)

Arguments:

  • field1, …: One or more data fields.
  • filter1, …: (optional) One or more data fields containing a filter value(s) that limit the values outputted. Filter values can reference cells, including cells with DROPDOWN selectors.
  • option1, …: (optional) Controls output with options explained in the guides: EVERY [change to show duplicates], LABELS [hide or show row heading labels], LIMIT[number of columns outputted], SORT [change order by field ascending or descending].

Examples

  • WRITE_H(product) - Horizontal row of product values.
  • WRITE_H(product, region) - Horizontal rows of product and region values.
  • WRITE_H(product | country{“USA”}) - Horizontal row of product values limited to those in the USA.
  • WRITE_H(product || SORT[product{!ZA}], LIMIT[5]) - Horizontal row of 5 product values sorted in descending (Z to A) order.