Addition of an row

[js_j]

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

[SURA]

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

DS User

[js_j]

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

thanks,
JJ

[nbalegar]

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.

[SURA]

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