How to Send Corresponding value

[Former Member]

Hi,

I hv 2-fields here like this...

F1 F2

-

---

A 1

B 2

C 3

D 4

I need to pic the heighest F2 corresponding value... How to do this can u

plz suggest me. (Means I need to send "D" from F1 column to target node)

regards,

Ansar.

[bhavesh_kantilal · Accepted solution]

Use the standard function SORTBYKEY.

F2 is the Key - First Parameter and F1 is the value Second Parameter in this case. The output will be as you want (D).

Regards

Bhavesh

[Former Member · Accepted solution]

thx a lot...solved my problem.

regards,

Ansar.