Skip to main content
Question

Wondering if it's at all possible to do a lookup with multiple match criteria?

  • March 11, 2025
  • 6 replies
  • 26 views

Louise Tang

Hi Team,Wondering if it's at all possible to do a lookup with multiple match criteria?Currently I am looking up the "index" value from a lookup.csv file based on matching hostname regex, which works fine as expected.But some customer index routing decisions need to match both hostname and appname (tag). So the logic would be something like:If hostname regex matches this pattern AND appname regex matches this pattern, take this index value as "index" field.I suspect this isn't possible with a lookup function... any ideas apart from many eval statements for each case?

6 replies

Jon Rust
Forum|alt.badge.img
  • Employee
  • March 11, 2025

works as you describe i think


Louise Tang
  • Author
  • Employee
  • March 11, 2025

Oh. Thats slightly embarrassing.:smile:


Jon Rust
Forum|alt.badge.img
  • Employee
  • March 11, 2025

hah


Jon Rust
Forum|alt.badge.img
  • Employee
  • March 11, 2025

no worries


Louise Tang
  • Author
  • Employee
  • March 11, 2025

I'll go away and self-flagellate and then test it. Thanks <@ULBGHDPNY&gt;


Louise Tang
  • Author
  • Employee
  • March 11, 2025

Follow up on this: works perfectly as expected. I am not sure how I missed it, but glad the feature is there already.