Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Lookup Functions - entitylookup

Table of contents
  1. entitylookup


  • {col1, col2} = entitylookup(field, entityName)

The entity information lists can be found in

If the field value matches the entityinfo lookup, return the specified columns. Empty table assignment is not supported for this function.


let EventID = f("@fields.EventID") 
aggregate count() by EventID
let {Description}= entitylookup(EventID, "AD_EventID")

In this example, “AD_EventID” is the entity name and “EventID” is the field.