DSXchange

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

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.

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

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?

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

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????

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?

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.

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

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?