for example suppose i have a search query which gives me results avg1 and name1,
and second search which gives a result avg2 and name2
now I want to create a table which contains these values of search1 & search2 as avgs and names
... eval add = x+y+z |eval name="xyz"|stats avg(add) as avg1
... eval add=d+e+f | eval name="abc"|stats avg(add) as avg2
now-- result should be
As previously mentioend you can use "append" or "appendcols", or you can use "join". If you use "join", you will need a common field to join on, but this can easily be accomplished by adding
... | eval joinOn="blahblahblah" to both searches, then use the new field "joinOn" (which has the same value in both searchs) as the field to join on.
I imagine you probably want to use append or appendcols though...
You may use the search command appendcols.
your_search_query_1| appendcols [search your_search_query_2]|