Is there a way to call 2 different data models in a search and join them with stats?

[clyde772]

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

[Yasaswy]

clyde772, try
|pivot DM_1..... join [|pivot DM_2...]|stats xx by yy

[clyde772]

Thanks! That's right, I always try to avoid join... I guess I have no more options..