I have a situation where I have to display one of many records depending which one is active. I already have a dataset the has all the records but it also has many other records. It would be nice to:
lookup(dataset,[‘name’,1], ‘Unknown’, [‘device’,‘state’],‘device’)
This would look for a record where device = “name” (* is wildcard) and state = 1 and return the name of the device or ‘Unknown’
Not looking for alternate ways. Just saying it would be nice to have.