Splunk Search

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

Communicator

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

0 Karma

Contributor

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

0 Karma

Communicator

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

0 Karma