Skip to content
Adaptam Docs

WRITE_V

Used to create vertical headings from data fields.

WRITE_V function overview

Function syntax

WRITE_V(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 column heading labels], LIMIT[number of rows outputted], SORT [change order by field ascending or descending].

Examples

  • WRITE_V(product) - Vertical column of unique product values.
  • WRITE_V(product, region) - Vertical columns of unique product and region combination values.
  • WRITE_V(product | country{“USA”}) - Vertical column of product values limited to those in the USA.
  • WRITE_V(product || SORT[product{!ZA}], LIMIT[10]) - Vertical column of 10 product values sorted in descending (Z to A) order.