Doubt regarding Aggregator

balu536 · Post by **balu536** » Wed Jul 01, 2009 10:32 am

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

nagarjuna · Post by **nagarjuna** » Wed Jul 01, 2009 10:39 am

Use the option : preserve type in aggregator

balu536 · Post by **balu536** » Wed Jul 01, 2009 10:42 am

please explain me in detail where actually in aggregator stage do we have the option

nagarjuna · Post by **nagarjuna** » Wed Jul 01, 2009 10:52 am

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 .

balu536 · Post by **balu536** » Wed Jul 01, 2009 10:54 am

Thank you

Regards,
Balakrishna

priyadarshikunal · Post by **priyadarshikunal** » Wed Jul 01, 2009 11:42 am

Time to mark this post as Resolved.

mkkgupta · Post by **mkkgupta** » Wed Oct 21, 2009 11:07 am

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!

nvuradi · Post by **nvuradi** » Fri Oct 30, 2009 1:31 pm

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?

nvuradi · Post by **nvuradi** » Fri Oct 30, 2009 1:32 pm

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?

chulett · Post by **chulett** » Fri Oct 30, 2009 2:03 pm

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?

nvuradi · Post by **nvuradi** » Fri Oct 30, 2009 3:34 pm

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

chulett · Post by **chulett** » Fri Oct 30, 2009 3:50 pm

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.

DSXchange

Doubt regarding Aggregator

Doubt regarding Aggregator

Optiion is missing!!