I have 2 lookups . first lookup have multiple fields including Hostname and the second lookup have only Hostname field . I want to find common Hostname from both lookups ,How can i do that?
Hi @Siddharthnegi ,You can use this query, this works if the field Hostname is there in both the lookups.
| inputlookup first_lookup where ([| inputlookup second_lookup | fields Hostname])
