Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Data Transformation
Data transformation operations use functions and expressions to functionally alter tabular data. These operations take 0, 1, or 2 tables as input and produce a single table as a result.
<tabu>
<tabu> defines a tabulation or cross-tabulation.
<break>
<break> specifies the sort order of the grouping column in a tabulation.

Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
- Data Transformation
  Data transformation operations use functions and expressions to functionally alter tabular data. These operations take 0, 1, or 2 tables as input and produce a single table as a result.
  - <amend>
    Update a specified value, or column of values, either by entering a new value or by using an expression. The expression can be applied to the column the value is in or to another column.
  - <base>
    <base> is the concrete macro operation that represents the action of opening the initial table.
  - <col>
    <col> changes the display attributes of a column in a table. It does not change the name of a column, but it does change the heading, as an example.
  - <colord>
    <colord> tells the system which columns to display and in what order.
  - <cols>
    Modifies the metadata of multiple columns at once, based on a query result or formatted tabular input.
  - <columns>
    <columns> is a special operation that retrieves column information from a table.
  - <directory>
    <directory> returns a table that provides information about the child objects of a particular folder. These include any tables, folders, and queries that have been saved to that folder.
  - <find>
    Efficiently finds (without selecting) the first n rows, between the specified row numbers, where the specified Boolean value expression is true.
  - <ignore>
    <ignore> encases code in a Macro Language query that should not be executed by the system.
  - <link>
    Link a foreign table to a base table or worksheet. Both tables must share a column on which to link.
  - <materialize>
    Creates a new physical table.
  - <merge>
    Merge a table to another table or worksheet.
  - <meta>
    <meta> allows settings to be made at the level of an individual query (and saved along with the query).
  - <note>
    <note> may be used to place a comment in the Macro Language. The contents of the element is any standard text.
  - <sel>
    Select the rows relevant to your analysis.
  - <sort>
    Changes the order in which rows appear in a table by sorting according to the values in a column.
  - <stats:>
    The <stats:> package provides more advanced statistics operations.
  - <table>
    <table> is a special operation that creates a temporary table within the scope of a query.
  - <tabu>
    <tabu> defines a tabulation or cross-tabulation.
    - <tcol>
      <tcol> defines a result column in a tabulation or cross-tabulation (e.g., average price).
    - <break>
      <break> specifies the sort order of the grouping column in a tabulation.
    - <rollup>
      Start with an arbitrary amount of data and tabulate it by grouping like values in a column or multiple columns.
  - <transpose>
    <transpose> results in a table in which the rows from the original table are its columns and the columns from the original table are its rows.
  - <willbe>
    Define a new computed column in an existing worksheet with a value expression.
- Blocks
  Blocks allow users to reuse sections of Macro Language code and to parameterize values in that code for greater flexibility and power.
- Application Development

`<break>`

<break> specifies the sort order of the grouping column in a tabulation.

Description

<break> specifies how a break column of a tabulation (i.e., a column in breaks or cbreaks) should be sorted. <break> tags are optional and may be specified for all, some, or none of the break columns. If not specified for a column, the column is not sorted.

Syntax

<tabu label="[TABULATION_TITLE]" breaks="[GROUPING_COLUMN]">
      <break col="[COLUMN_NAME]" sort="[SORT_DIRECTION]"></break>
      <tcol source="[AGGREGATION_COLUMN]" fun="[FUNCTION]"
            label="[COLUMN_HEADING]"/>
</tabu>

Attributes

col

The name of the column.

col is required.

sort

Specifies whether the tabulation results should be sorted or not.

up: Sort the tabulation results so that this column is in ascending order.
down: Sort the tabulation results so that this column is in descending order.
none: Do not sort using this column.

naorder

If a sort is specified, whether to place N/A values first or last in the collation order.

The default is first.

placeholder

If this tabulation includes a <rollup> element, the value to use in place of N/A for rolled-up breaks.

The value must be of the same type (text, integer, real number) as the break column. If the break is a text column, then this value should be enclosed in single quotes within double quotes (e.g., placeholder="'ALL'"). The default is no placeholder (i.e., N/A is used).

rename

The break column may optionally be renamed from its pre-tabulation name. If present, rename specifies the new column name.

The default is not to rename.

relabel

The break column may optionally be given a different header (label) than its pre-tabulation header. If present, relabel specifies the new column header.

The default is not to relabel.

Example

In this example, the base table is pub.demo.retail.item.

<base table="pub.demo.retail.item"/>
<tabu label="Tabulation on Sales Item Detail" breaks="store" cbreaks="transid">
    <break col="store" sort="down"/>
    <tcol source="sales" fun="sum" label="Sum of`Sales"/>
</tabu>