topic How to fetch data from multiple source types in a dashboard ? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-fetch-data-from-multiple-source-types-in-a-dashboard/m-p/204263#M176254 <P>Hi Team, </P> <P>I have three sourcetypes, all the sourcetypes have two or three common fields , how to extract the data as it should fetch data from all three source type<BR /> for ex: Field "City" is common in all source types, to display it on a dashboard using dropdown, what will be the search query or suggest some way to start on this</P> <P>My idea is to execute search string : input lookup file1.csv file2.csv file3.csv|stats city as City is this correct ? <BR /> or is there any convenient way to fetch it easily</P> Thu, 03 Nov 2016 13:42:11 GMT rijinc 2016-11-03T13:42:11Z How to fetch data from multiple source types in a dashboard ? https://community.splunk.com/t5/Splunk-Search/How-to-fetch-data-from-multiple-source-types-in-a-dashboard/m-p/204263#M176254 <P>Hi Team, </P> <P>I have three sourcetypes, all the sourcetypes have two or three common fields , how to extract the data as it should fetch data from all three source type<BR /> for ex: Field "City" is common in all source types, to display it on a dashboard using dropdown, what will be the search query or suggest some way to start on this</P> <P>My idea is to execute search string : input lookup file1.csv file2.csv file3.csv|stats city as City is this correct ? <BR /> or is there any convenient way to fetch it easily</P> Thu, 03 Nov 2016 13:42:11 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-data-from-multiple-source-types-in-a-dashboard/m-p/204263#M176254 rijinc 2016-11-03T13:42:11Z Re: How to fetch data from multiple source types in a dashboard ? https://community.splunk.com/t5/Splunk-Search/How-to-fetch-data-from-multiple-source-types-in-a-dashboard/m-p/204264#M176255 <P>if they are lookup files, maybe something like this:</P> <PRE><CODE>|inputlookup file1.csv|table City|append [|inputlookup file2.csv|table City]|append [|inputlookup file3.csv|table City]|stats count by City|fields - count </CODE></PRE> Thu, 03 Nov 2016 14:12:38 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-data-from-multiple-source-types-in-a-dashboard/m-p/204264#M176255 cmerriman 2016-11-03T14:12:38Z