Implementing Greatest,Least Function in Datastage

srini.dw · Post by **srini.dw** » Wed Nov 29, 2006 5:21 am

Hi,

How can findout among 5 date columns Greatest Date,Least Date in DataSatge7.5 PX

Raghavendra · Post by **Raghavendra** » Wed Nov 29, 2006 5:39 am

Convert the dates to julian date and compare them..

keshav0307 · Post by **keshav0307** » Wed Nov 29, 2006 5:54 am

is the aggregate function for min and max, not working???

then sort the data, 1st is the least and last is the Greatest.

srini.dw · Post by **srini.dw** » Wed Nov 29, 2006 6:42 am

I need Like this

GDate=Greatest(Date1,Date2,Date3,Date4,Date5)
LDate=Least(Date1,Date2,Date3,Date4,Date5)

How Can do that in DataStage PX

srini.dw · Post by **srini.dw** » Wed Nov 29, 2006 6:57 am

I have Columns in redord coming as Gdate1,Gdate2,Gdate3,Gdate4,Gdate5 in that find out Gdate this is Greatest one.Like that for Ldate1,Ldate2,Ldate3,Ldate4,Ldate5 in that find out Ldate.

keshav0307 · Post by **keshav0307** » Wed Nov 29, 2006 7:27 am

GDate=Max(Max(Max(Max(Date1,Date2),Date3),Date4),Date5)