Page 1 of 1
Doubt regarding Aggregator
Posted: Wed Jul 01, 2009 10:32 am
by balu536
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
Posted: Wed Jul 01, 2009 10:39 am
by nagarjuna
Use the option : preserve type in aggregator
Posted: Wed Jul 01, 2009 10:42 am
by balu536
please explain me in detail where actually in aggregator stage do we have the option
Posted: Wed Jul 01, 2009 10:52 am
by nagarjuna
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 .
Posted: Wed Jul 01, 2009 10:54 am
by balu536
Thank you
Regards,
Balakrishna
Posted: Wed Jul 01, 2009 11:42 am
by priyadarshikunal
Time to mark this post as Resolved.
Optiion is missing!!
Posted: Wed Oct 21, 2009 11:07 am
by mkkgupta
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!
Posted: Fri Oct 30, 2009 1:31 pm
by nvuradi
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 .
I am working on 7.5.1 OS: Unix, but i do not see this option in Aggregator stage..
any idea how to enable this?
Posted: Fri Oct 30, 2009 1:32 pm
by nvuradi
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 .
I am working on 7.5.1 OS: Unix, but i do not see this option in Aggregator stage..
any idea how to enable this?
Posted: Fri Oct 30, 2009 2:03 pm
by chulett
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?
Posted: Fri Oct 30, 2009 3:34 pm
by nvuradi
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? ...
Yes I did..all I could see are many options but not Preserve Type.
The availabe properties are:
Corrected Sum of Squares Output Column, Max Value output column so on
Posted: Fri Oct 30, 2009 3:50 pm
by chulett
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.