rowNames
Returns a list of all row names in a table.
The row name is the value in the table's first column.
You can specify a table region using the first parameter. By default, the function interrogates the whole table.
The list or row names reflects the row order in the data (working top to bottom).
Note
Available in "Describe the Table" and "Describe Row in Context" projects only.
Parameters
REGION (table region)
Optional. The input table region.
Default: The whole table.
Examples
Assume a "Describe the Table" project with this data:
Branch | Manager | Sales | COGS | otherExp | Profit | |
|---|---|---|---|---|---|---|
Row 1 | Aberdeen | Andrew Gray | 14,000 | 8,000 | 1,500 | 4,500 |
Row 2 | Edinburgh | Emma Moore | 33,000 | 19,000 | 3,500 | 10,500 |
Row 3 | Inverness | Linda Barclay | 16,000 | 8,250 | 1,500 | 6,250 |
Row 4 | Glasgow | Louise Scott | 32,500 | 17,750 | 1,700 | 13,050 |
If the optional parameter is unspecified, the function interrogates the whole table.
ATL in Script | Result |
|---|---|
| Aberdeen, Edinburgh, Inverness and Glasgow |
Note
The row name is the value in the table's first column.
Any input to the optional parameter should return a table region.
ATL in Script | Result |
|---|---|
[[ filteredData = filterRows(WholeTable, Sales, gt(30000)) rowNames(filteredData) ]] | Edinburgh and Glasgow |
The first line uses filterRows to get rows with a Sales value greater than 30,000. This ATL is assigned to a variable called filteredData. The second line gets the row names from the filtered data.
