Extracts every cell value of a map, together with its coordinates, into a single table with one row per cell.
| Name | Type | Description |
|---|---|---|
| Map | Map Type | Input map. |
| Name | Type | Description | Default Value |
|---|---|---|---|
| Keys Type | Enum Type | Determines how each output row's unique “Id” is generated. With Default, the id is assigned randomly when execution is parallel, or sequentially otherwise. With Use Map Values As Keys, the cell's own value is used as its id. With Use Coordinate Indexes as Keys, the cell's coordinate index (row-major position) is used as its id. | Default |
| Include Null Values | Boolean Value Type | If true, cells whose value equals Map's null value are also included in the output table. | No |
| Name | Type | Description |
|---|---|---|
| Cells | Table Type | Resulting table of cell values and coordinates. |
Cells has the following format:
| Column Name | Key or Data? | Column Type | Description |
|---|---|---|---|
| “Id” | Key | Real | Unique row identifier, generated as determined by Keys Type. |
| “Value” | Data | Real | The cell's value. |
| “Line” | Data | Real | The cell's line, with the topmost line indexed as 1. |
| “Column” | Data | Real | The cell's column, with the leftmost column indexed as 1. |
By default, cells equal to Map's null value are skipped, unless Include Null Values is true.
Raises an error if Keys Type is Use Map Values As Keys and Map has more than one layer, since a cell value would then no longer be unique across layers.
ExtractMapValues