Transformer logic required

[deesh]

Hi,

find belo criteria and required output

Input
-------

Code: Select all

type  amount  city

A                    NW
B       200
A                    DL
B        500

Output
--------

Code: Select all

Type    Amount   
A            700

I required like above output need to get two rows record into single row record.

Please can any one help in this case

[chulett]

What have you tried?

[deesh]

Problem has been solved with used by lookup and aggregator stage...