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
Addition of an row
Moderators: chulett, rschirm, roy
Re: Addition of an row
In the TFM take one more link with constraint and do transformation. Then funnel it.
DS User
DS User
Re: Addition of an row
Hi,
Thanks for the reply.
Could u be more specific on the transformation in the TFM?
thanks,
JJ
Thanks for the reply.
Could u be more specific on the transformation in the TFM?
thanks,
JJ
Re: Addition of an row
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.
Last edited by nbalegar on Wed Aug 24, 2011 6:07 am, edited 1 time in total.
Re: Addition of an row
Code: Select all
--------AllDatas----------
source--->copy | funnel
----FilterStage-->TFM-----
DS User