Is there a way to call 2 different data models in SPL to join them with stats? I have tried multisearch, but didn't work. like this :
| multisearch [ | pivot. DM_1.... ] [ | pivot ..DM_2.... ] | stats xx by yy
clyde772, try
|pivot DM_1..... join [|pivot DM_2...]|stats xx by yy
Thanks! That's right, I always try to avoid join... I guess I have no more options..