DSXchange

Posted: **Tue Jun 16, 2009 2:08 pm**

Hi
I have a feild XX
Wich is of varchar datatype has the values
like
1000007
562369p
12-52-00
1-po-023
90-op-88
I have to take max of it

Thanks

Posted: **Tue Jun 16, 2009 3:42 pm**

According to you which is max of below values and why ??

1000007
562369p
12-52-00
1-po-023
90-op-88

Posted: **Tue Jun 16, 2009 4:45 pm**

Aggregator stage to calculate MAX.

Sort then use Remove Duplicates stage. For example, if sort is ascending, have Remove Duplicates pass only the last record in each group.

DSXchange

max of two varchar

max of two varchar