DSXchange

Posted: **Tue Oct 22, 2013 9:54 am**

Hi,

find belo criteria and required output

Input
-------

type  amount  city

A                    NW
B       200
A                    DL
B        500

Output
--------

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

Posted: **Tue Oct 22, 2013 9:56 am**

What have you tried?

Posted: **Tue Oct 22, 2013 11:21 am**

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

Transformer logic required