Specify Distinct Output Rows
In an XML Map transform, if a column specified in the Distinct tab contains a distinct value, the row is a new output row.
To add a column to the Distinct columns list, select the column in the output schema area and drag it to the list in the Distinct tab. SAP Cloud Integration for data services adds the column to the bottom of the list.
To remove a column, select the column and select the delete icon.
To consider the entire output row as distinct, select Whole row is DISTINCT.
When source columns are used, they must descend from the source schemas in the current iteration rule. In addition, the path from the source schema to the column must contain no repeatable nodes.
When target columns are used, they must descend from the selected target schema. In addition, the path from the selected target schema to the column must contain no repeatable nodes.