Merge
Relational functions merge
- merge(option,valuesunit, option1values, .. , optionnvalues)
merge(option, valuesunit, option1values, .. , optionnvalues) results in a data item with the domain unit of data items:
- option, option1values, .. , optionnvalues and as
- valuesunit the second argument: valuesunit.
The resulting values are the one of the values of the set: option1values, .. , optionnvalues.
The first argument (option) indicates from which optionvalue attribute the values are selected. So an option of 0 means the values are selected from the option1values attribute and an option of 2 means they are selected from the option3values attribute.
- data items with Numeric or value types
- option attribute with uint8 value type
- domain units of all data items must match or be void.
- all optionvalues arguments must have matching:
- value type
- metric
7.184
unit<float32> eur;
attribute<eur> TransportCosts (ADomain) := merge(TransportOption, eur, car, public, bike);
| Transport Option |
car(eur), sequencenr: 0 |
public(eur), sequencenr: 1 |
bike(eur), sequencenr: 2 |
Transport Costs |
|---|---|---|---|---|
| 0 | 18 | 15 | 12 | 18 |
| 2 | 28 | 25 | 22 | 22 |
| 1 | 38 | 35 | 32 | 35 |
| null | 48 | 45 | 42 | null |
| 1 | 58 | 55 | 52 | 55 |
ADomain, nr of rows = 5
