Reference table (multiple match)

[#1]

Have one driver table and want to reference based on one column and in reference table i have multiple records but i need to pick which is earlier (date), how can i achieve this, please need your suggestions.

[er_mohit]

Use firsorted value concept function for getting max record on the base of date  and group by that one column

like

load * from orignial table;

load PrimaryKeyfield,

max(Recordfield) as Record,

firstsortedvalue(Datefield,-Record) as EarlierDate

resident originaltable

group by PrimaryKeyfield,;