I think this is simple and I think I see similar questions, but I've failed to implement them for my case and any help is gratefully received.
I have 2 searches that end in two tables with variable numbers of rows.
1)
table, mac, stat1, stat2, stat3, stat4
2)
table, macAddress, hostname
Every mac can be found in a row of macAddress. So I want:
*)
table, hostname, stat1, stat2, stat3, stat4
But I can't work out how. Lookups seem to static, subsearchs seem to only pass information in 1 direction I can append searches but that is just a mess. I haven't had much luck parsing other questions for useful answers. Any inspirations?
... View more