Select_data
Relational functions select_data
- select_data(domain unit, condition, attribute)
The select_data(domain unit, condition, data item) function results relates the attribute argument to the domain unit argument, based on the condition argument.
The select_data is usually used together with the select unit function. This select unit is used to make the domain unit.
- unit domain unit with value type uint32
- condition must be a boolean attribute or subexpression resulting in boolean values.
- attribute, an attribute that must have matching value type and metric with the resulting attribute.
7.305
unit ZHCities := select_unit(City/RegionCode == 200)
{
attribute name := select_data(., City/RegionCode == 200, City/Name);
}
| City/RegionCode | City/Name |
| 100 | Amsterdam |
| 200 | Rotterdam |
| 300 | Utrecht |
| 200 | Den Haag |
| 400 | Eindhoven |
| null | Haarlem |
| 400 | Tilburg |
domain City, nr of rows = 7
| ZHCities/name |
| Rotterdam |
| Den Haag |
domainZHCities, nr of rows = 2
