value based on 2 fields

[#1]

Hi,

i've got 2 colums (RecNo and RUECK). Now I want to get the value from column 3 for each DISTINCT RUECK Where RecNo is max (see attachment)

So for RUECK 1 I need the value 5 (RecNo 3)

How can I do this?

Tnx.

Rey-man

[#2]

Hi Rey man,

Please find attached modified version for your issue to display details when the Recno is max for RUECK.

However u can try to derive rank in the source database/excel and then can restrict the records in the where clause of the load statement.

Regards,

Poorva

[#3]

Hi Rey man,

Please find attached modified version for your issue to display details when the Recno is max for RUECK.

However u can also try to derive rank in the source database/excel and then can restrict the records in the where clause of the load statement.

Regards,

Poorva