====== SelectDistinct ======


The SelectDistinct function allows you to return only one value from duplicate values. The same values must be in the same document. Otherwise, use [[en:transformation:mappings:funktionen:gruppierung:selectdistinctvalue|SelectDistinctValues]].

**Note:** Attributes to be filtered are without @, see example!

==== Syntax: ====

<code>SelectDistinct('Node/SubNode', 'Attribut', 'SortAttribute')</code>

==== Sample: ====

<code>SelectDistinct('Pricat/Position', 'EAN')</code>
<code>SelectDistinct('Pricat/Position', 'EAN', 'EAN')</code>


Regroup INVRPT with several QTY and LOC specifications on items by location:
<code>SelectDistinctValues('SG_9/SG_11/LOC/DG_C517/@DE_3225')</code>
{{:transformation:mappings:funktionen:gruppierung:select_distinct_locations_invrpt.png|}}