DSXchange

Posted: **Tue Aug 23, 2011 8:27 pm**

Hi,
I have to add an extra row in the output file for every employee with the following calculation from the input file.

I/P file:
A B C D
2011;40S0;12.50,123456
2011;50S0;12.45;123456
2011;40FR;13.56;123456; etc...

Now each and every employee with the values (40S0 and 50S0) the values of C column should be added and subtracted from the C column with the value (40FR)

i.e Newrow (new row) = 12.50 +12.45 - 13.56.

kindly advice on the above scenario.

thanks,
JJ

Posted: **Tue Aug 23, 2011 9:07 pm**

In the TFM take one more link with constraint and do transformation. Then funnel it.

DS User

Posted: **Tue Aug 23, 2011 9:41 pm**

Hi,
Thanks for the reply.
Could u be more specific on the transformation in the TFM?

thanks,
JJ

Posted: **Tue Aug 23, 2011 11:49 pm**

Can you be more specific on the requirement, what is the unique keya and when you generate the new row what are the other column values. These two values are constant values or its going to change for the records.

Posted: **Wed Aug 24, 2011 12:46 am**

Code: Select all

                       --------AllDatas----------
source--->copy                                   | funnel 
                     ----FilterStage-->TFM-----

in the filter stage make an condition to pass only if the values are xyz. In the TFM do add / whatever.

DS User

DSXchange

Addition of an row

Addition of an row

Re: Addition of an row

Re: Addition of an row

Re: Addition of an row

Re: Addition of an row