Hi, i have two files
| inputlookup ABC | stat count
result=10
| inputlookup XYZ | stat count
result=20
i want to get results as 30 by adding these two files
Like this-
|inputlookup ABC|stats count|append[|inputlookup XYZ|stats count]|stats sum(count) as count
Like this-
|inputlookup ABC|stats count|append[|inputlookup XYZ|stats count]|stats sum(count) as count
A minor comment for you - this works great but inputlookup actually has its own append=t
argument that you can use. And in this case it's better to use it, than to rely on the append
command because append
hits failsafe at 50,000 rows where it would truncate.
So long story short you can just do:
| inputlookup ABC | inputlookup XYZ append=t | stats count
wow its working...wonderful answer
Please move to answer
This work
(search1) OR (search2) |inputlookup ABC |inputlookup XYZ |stats count
thanks for your response but it not working