Can you help me count the following two files?

[logloganathan]

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

[493669 · Accepted solution]

Like this-

|inputlookup ABC|stats count|append[|inputlookup XYZ|stats count]|stats sum(count) as count

[sideview]

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

[logloganathan]

wow its working...wonderful answer

[logloganathan]

Please move to answer

[grantsmiley]

This work

(search1) OR (search2) |inputlookup ABC |inputlookup XYZ |stats count

[logloganathan]

thanks for your response but it not working