Aggregator Stage Min & Max

mgendy · Post by **mgendy** » Sun Nov 01, 2009 8:07 am

Hi All,

i just have a little question , does Aggregator Stage min and max functions support time stamps , i tried to use it but it gives an error saying that couldn't convert from timestamp to dfloat , but i beleive that it worked with me before but in another envirnoment , i just ask to know the ability of doing that

chulett · Post by **chulett** » Sun Nov 01, 2009 8:59 am

The only way it might work is if you add the 'Preserve Type' option and it seems that wasn't added until the 7.5.2 release. Let us know.

mgendy · Post by **mgendy** » Mon Nov 02, 2009 3:15 am

chulett wrote:The only way it might work is if you add the 'Preserve Type' option and it seems that wasn't added until the 7.5.2 release. Let us know. ...

yes yes yes , it is working now , many thanks chulett for your help

synsog · Post by **synsog** » Wed Oct 20, 2010 7:50 am

Where to add this preserve type option? could you pls help me out? I need to perform the max funtion on string column. can i do that?

anbu · Post by **anbu** » Wed Oct 20, 2010 8:03 am

Yes you can do max on string. When you select Column for Calculation, you can see the Preserve type as one of the properties

synsog · Post by **synsog** » Wed Oct 20, 2010 8:06 am

anbu wrote:Yes you can do max on string. When you select Column for Calculation, you can see the Preserve type as one of the properties

could you please tell where do i get that? Please????

chulett · Post by **chulett** » Wed Oct 20, 2010 9:50 am

As noted, it's an additional property you can add, just like any of the other additional properties. What version of DataStage do you have?

synsog · Post by **synsog** » Wed Oct 20, 2010 10:46 pm

chulett wrote:As noted, it's an additional property you can add, just like any of the other additional properties. What version of DataStage do you have?

Its 7.5.1.

chulett · Post by **chulett** » Wed Oct 20, 2010 11:10 pm

I asked because, unless I was wrong back when I posted this:

chulett wrote:it seems that wasn't added until the 7.5.2 release

synsog · Post by **synsog** » Thu Oct 21, 2010 12:10 am

chulett wrote:I asked because, unless I was wrong back when I posted this:

chulett wrote:it seems that wasn't added until the 7.5.2 release

Thanks, is there any way out to get maximum value on string column?