Doubt regarding Aggregator
Moderators: chulett, rschirm, roy
Doubt regarding Aggregator
Hi all,
Can we perform Max function present in the Aggregator stage on the Varchar data.If so please explain me the procedure how to preserve the datatype as the output datatype of a Max function is Double by default.
Regards,
Balakrishna
Can we perform Max function present in the Aggregator stage on the Varchar data.If so please explain me the procedure how to preserve the datatype as the output datatype of a Max function is Double by default.
Regards,
Balakrishna
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Optiion is missing!!
priyadarshikunal wrote:Time to mark this post as Resolved.
I am using 7.5.1 and I am doing a max on two columns belong to varchar & date.
I am unable to find preserver property in the available properties to add.
Appreciated for your help!
Regards
Kiran
Kiran
I am working on 7.5.1 OS: Unix, but i do not see this option in Aggregator stage..nagarjuna wrote:balu536 wrote:please explain me in detail where actually in aggregator stage do we have the option
Stage --> properties --> Agrregations ---> aggregation type calculation --> click on column for calculation --> see in available properties to add .
any idea how to enable this?
I am working on 7.5.1 OS: Unix, but i do not see this option in Aggregator stage..nagarjuna wrote:balu536 wrote:please explain me in detail where actually in aggregator stage do we have the option
Stage --> properties --> Agrregations ---> aggregation type calculation --> click on column for calculation --> see in available properties to add .
any idea how to enable this?
Yes I did..all I could see are many options but not Preserve Type.chulett wrote:The instructions worked just fine for me but then I'm on 7.5.2. Did you highlight the Column for Calculation then scroll the Available Properties to Add over to the right? ...
The availabe properties are:
Corrected Sum of Squares Output Column, Max Value output column so on
They are in alpha order, so you'd need to keep going. There are 18 options in all and 'Preserve Type' is between 'Percent Coefficient of Variation Output Column' and 'Range Output Column'. If you don't see that, then I guess it was something added in 7.5.2 and you would get it if you upgraded.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers