Selecting max Date Record

[iwin]

Hi,
I have two records source with same keys but the only difference is the Date field. And i need to pick the record which has a max date and ignore the other record.

Please advice me.

Thanks In Advance

[ArndW]

What datatype and format is your date column? If it is a string in the form of yyyy-mm-dd then a simple string comparison will suffice.

[rwierdsm]

Assuming that the source is a flat file, run the data through an aggregator, grouping by all the fields except the date field then select the max date. Only one row will survive the aggregation.

If the source is an RDBMS, you could do something similar using a group by in the SQL.

HTH,

Rob W

[iwin]

Hi,
It worked by giving group by in SQL.

Thanks Guys