Get unique values

[Former Member]

Hi all

I am getting following values against Material and Quantity

M1 - 10

M2 - 20

M2 - 20

M3 - 30

M4 - 40

M4 - 40

M5 - 50

I need result as

M1 - 10

M2 - 20

M3 - 30

M4 - 40

M5 - 50

Basically i need to eliminate duplicates

Please let me know the process to get the proper format in result

-keerthi

[Former Member]

Self answered

[Former Member]

Hi,

use in mapping the node function SpliByValue(ValueChange) and next the collapseContext function.

in Detail:

Target Item:

Concat Material and Quantity -> SplitByValue(Value Change) -> collapseConexte -> Target Item

Target Material

Concat Material and Quantity -> SplitByValue(Value Change) -> formateByExample(with Material Field) -> collapseContext - > SplitByValue(eachValue)

Target Quantity

Same like material just use formatByExample with Quantity Field

Note: Don't forget to change the context in source Fields.

regards,

Robin

Edited by: Robin Schröder on Aug 5, 2010 2:11 PM