common fields

[Siddharthnegi]

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?

[manjunathmeti]

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])