GroupByEx

The GroupByEx function not only selects only one value from duplicate values, but is also able to process up to 6 grouping criteria Key1, Key2, …, Key6. The grouping criteria themselves can also include other functions. \
As a result, a list with the different results of the grouping criteria is returned as a NodeSet, which can be further processed by XPath in the further mapping process..

Note It is possible to group attributes that are located in different depths of the node levels. To do this, however, the node must point to the lowest level. The hierarchically higher-ordered attributes must then be added by a „… /“ reference.

Syntax:

GroupByEx('Node', 'Key1', 'Key2', 'Key3', ... , 'Key6')

GroupByEx('Node', 'Attribut1', 'Attribut2', 'Attribut3')

Samples:

Group under/InventoryReport/Items by @Ean:
```
GroupByEx(/InventoryReport/Items, "@Ean")
```
Return a list of all LIN nodes, grouped by the DE_7140 attributes whose DE_7143 attribute contains the value' GU'.:
```
GroupByEx(//LIN, "../PIA/*[@DE_7143='GU']/@DE_7140")
```
Return a list of all SG_33 nodes, grouped by the DE_7140 attributes whose DE_7143 attribute contains the value' GU'.:
```
GroupByEx(//SG_33, "PIA/*[@DE_7143='GU']/@DE_7140")
```
Return a list of all LIN nodes, grouped by the article details color attributes whose EAN is equal to the value in the DE_7140 attribute.:
```
GroupByEx(//LIN, "GetArticleDetailsByEAN(DG_212/@DE_7140)/Detail/@Color")
```

Example for a concatenated key value:

GroupByEx(/INVOIC/SG_25, 'concat(LIN/DG_C212/@DE_7140, LIN/DG_C212/@DE_7143)')

Note:: Many more examples can be found under GroupByExSorted .