====== 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..\\ 

{{:images:sign_warning.png?nolink|}}**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: ====

<code>GroupByEx('Node', 'Key1', 'Key2', 'Key3', ... , 'Key6')</code>
<code>GroupByEx('Node', 'Attribut1', 'Attribut2', 'Attribut3')</code>

==== Samples: ====

  * Group under/InventoryReport/Items by @Ean:<code>GroupByEx(/InventoryReport/Items, "@Ean")</code>
  * Return a list of all //LIN nodes//, grouped by the DE_7140 attributes whose DE_7143 attribute contains the value' GU'.:<code>GroupByEx(//LIN, "../PIA/*[@DE_7143='GU']/@DE_7140")</code>
  * Return a list of all //SG_33 nodes//, grouped by the DE_7140 attributes whose DE_7143 attribute contains the value' GU'.:<code>GroupByEx(//SG_33, "PIA/*[@DE_7143='GU']/@DE_7140")</code>
  * 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.:<code>GroupByEx(//LIN, "GetArticleDetailsByEAN(DG_212/@DE_7140)/Detail/@Color")</code>
  * Example for a concatenated key value:<code>GroupByEx(/INVOIC/SG_25, 'concat(LIN/DG_C212/@DE_7140, LIN/DG_C212/@DE_7143)')</code>
{{:images:sign_warning.png?nolink|}}**Note:**: Many more examples can be found under  [[en:transformation:mappings:funktionen:gruppierung:groupbyexsorted]] .