Hi,
In the aggregator stage, is there an option that the o/p of summation of a decimal field is produced in the desired decimal format - without any leading / trailing zeroes.
From example -(i/p and o/p from aggregator based on a key)
I/P --fld1 values--100,200, 300
O/P--Sum(fld)1---600.0 [and NOT 000006000.00 for dataype decimal(11,2) ]
I understand it can be handled later in downstream using a transformer stage. I am looking for a direct solution - possibly in the aggregator stage itself.
Thanks,
Nitin
Aggregator O/p Data on summation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A following Transformer stage would seem to be the easiest. And/or a build op if you're into coding of these beasts. The build op gives you greater flexibility in handling out of range values (precision 22 may not handle all Double numbers).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.