Adding the amount column value from Sequencial file.

laknar · Post by **laknar** » Tue Nov 25, 2008 12:14 am

Hi,

I'm reading from fixed width file.
in that i have a amount column starts with + or -

i.e -10.00
-12.12
+14.98
+25.78

im reading the file as squential mode.
i want to sum the column + seperately and - values seperately.

and finally differences for + values and -Values.
how can i acheive this.

bi_fujitsu · Post by **bi_fujitsu** » Tue Nov 25, 2008 1:18 am

Convert to Decimal first and then use an aggregator stage to calculate the sum. Even if the order is sequential, it should give you correct sum irrespective of the sign.
-10+5 is always going to be -5.

laknar · Post by **laknar** » Tue Nov 25, 2008 2:10 am

From source itself im getting as decimal value.
how can i convert.
please suggest me.

us1aslam1us · Post by **us1aslam1us** » Tue Nov 25, 2008 2:20 am

If your source already have it as decimal then what is stopping you to use aggregator for Summing those values??

bi_fujitsu · Post by **bi_fujitsu** » Tue Nov 25, 2008 2:27 am

if it's decimal in source, then there is no need of any type conversion. Use an aggregator stage to perform regular summation.