>Your search would do a search like this (using 'if' rather than coalesce) search index_a_dataset OR index_b_dataset
| eval f1=if(index="A", field1, field4)
| eval f2=if(index="B", field2, field5)
| stats values(field3) as f3 values(field6) as f6 by f1 f2 can I "join" to use this search sentence without "join" command? | eval f1=if(index="A", field1, field4)
| eval f2=if(index="B", field2, field5) Can I rewrite | eval f2=if(index="B", field2, field5) to | eval f2=if(index="A", field2,field5) ?
... View more