topic Re: Is there a way to call 2 different data models in a search and join them with stats? in Splunk Search https://community.splunk.com/t5/Splunk-Search/Is-there-a-way-to-call-2-different-data-models-in-a-search-and/m-p/134960#M36884 <P>clyde772, try <BR /> |pivot DM_1..... join [|pivot DM_2...]|stats xx by yy</P> Mon, 28 Sep 2020 19:31:57 GMT Yasaswy 2020-09-28T19:31:57Z Is there a way to call 2 different data models in a search and join them with stats? https://community.splunk.com/t5/Splunk-Search/Is-there-a-way-to-call-2-different-data-models-in-a-search-and/m-p/134959#M36883 <P>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 :</P> <P>| multisearch [ | pivot. DM_1.... ] [ | pivot ..DM_2.... ] | stats xx by yy</P> Mon, 28 Sep 2020 19:28:25 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-a-way-to-call-2-different-data-models-in-a-search-and/m-p/134959#M36883 clyde772 2020-09-28T19:28:25Z Re: Is there a way to call 2 different data models in a search and join them with stats? https://community.splunk.com/t5/Splunk-Search/Is-there-a-way-to-call-2-different-data-models-in-a-search-and/m-p/134960#M36884 <P>clyde772, try <BR /> |pivot DM_1..... join [|pivot DM_2...]|stats xx by yy</P> Mon, 28 Sep 2020 19:31:57 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-a-way-to-call-2-different-data-models-in-a-search-and/m-p/134960#M36884 Yasaswy 2020-09-28T19:31:57Z Re: Is there a way to call 2 different data models in a search and join them with stats? https://community.splunk.com/t5/Splunk-Search/Is-there-a-way-to-call-2-different-data-models-in-a-search-and/m-p/134961#M36885 <P>Thanks! That's right, I always try to avoid join... I guess I have no more options..</P> Tue, 14 Apr 2015 16:44:19 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-a-way-to-call-2-different-data-models-in-a-search-and/m-p/134961#M36885 clyde772 2015-04-14T16:44:19Z