Sort on two fields and create one target node

[Former Member]

Please let me know if we can achieve the below using graphical mapping:

Source:

Field1     Field2     Field3

4002       100         200.00

4002       100         350.00

4002       110         150.00

4004       110         100.00

4006       210          500.00

4006       210          600.00

Target:

Field1     Field2     Field3

4002       100         550.00

4002       110         150.00

4004       110         100.00

4006       210         1100.00

Thanks,

Vertika

[former_member190293 · Accepted solution]

Hi Vertika!

Regards, Evgeniy.

[Former Member · Accepted solution]

Thanks Evgeniy

This worked.

[former_member186851]

Hello Vertika,

For Field one and field two

Source--removecontexts-->Sort-->splitbyvalue{value change}--->Collapsecontexts---Target

Field three is it a addition?

check the below link

[Former Member]

Hi Sritharan,

I have to create target node with unique combination of Field1 and Field2.

And in this scenario Field1 and Field2 will keep on changing.

Source in above example has 6 rows and I need four target rows as output with unique combination of Field1 and Field2.

Yes Field 3 will be addition of amount for unique combination.

I don't think the logic you explain above will work in this scenario. I am trying to use sort by key but not able to achieve.

[Harish]

Hi Vertika,

Please refer the below mapping logic

root

fields

test result