Discussion

3
Replies
1248
Views
Close popover
Otto Perdeck (Otto_Perdeck)
PEGA
Principal Decisioning Architect
Pegasystems Inc.
NL
Otto_Perdeck Member since 2010 9 posts
PEGA
Posted: October 30, 2015
Last activity: November 13, 2015
Closed

How to do VLOOKUP like lookup in an expression?

Suppose I have a Page List of Customers

 

Assume the Customer data model is - in pseudo notation - like this:

 

Customer {

ID : text,

Income : double

}

 

ID Income
CE-1 200
CE-2 500
CE-3 150

 

Now I would like to get the ID of the customer with the highest income. So in this example, that would be CE-2.

 

What PRPC expression would give me this (a la Excel vlookup)?

 

Thanks!

 

Otto

Case Management
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.