https://community.splunk.com/t5/Splunk-Search/How-to-use-the-result-from-one-function-into-another-function/m-p/565290#M196947 <P>Hello all, I need help with this :((<BR />How to use derivatives of 1st function results into the 2nd function in splunk? Please see the example below:</P><P>1st function: for instance, from the first eval, i got the names of the top 100 sold fruits and their respective companies.</P><P>2nd function: From this top 100 fruits, I would like to then, search for the fruits import-export countries (ie the export country (origin) and imported (destination) country). Each of the fruits may have more than 1 set of export-import. How do I go about doing it? What's the syntax to get the top 100 fruits into the second function? Any guidance appreciated</P> Tue, 31 Aug 2021 08:18:27 GMT splunkymage 2021-08-31T08:18:27Z https://community.splunk.com/t5/Splunk-Search/How-to-use-the-result-from-one-function-into-another-function/m-p/565290#M196947 <P>Hello all, I need help with this :((<BR />How to use derivatives of 1st function results into the 2nd function in splunk? Please see the example below:</P><P>1st function: for instance, from the first eval, i got the names of the top 100 sold fruits and their respective companies.</P><P>2nd function: From this top 100 fruits, I would like to then, search for the fruits import-export countries (ie the export country (origin) and imported (destination) country). Each of the fruits may have more than 1 set of export-import. How do I go about doing it? What's the syntax to get the top 100 fruits into the second function? Any guidance appreciated</P> Tue, 31 Aug 2021 08:18:27 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-the-result-from-one-function-into-another-function/m-p/565290#M196947 splunkymage 2021-08-31T08:18:27Z https://community.splunk.com/t5/Splunk-Search/How-to-use-the-result-from-one-function-into-another-function/m-p/565292#M196949 <P>You can use the results of one search to filter the results of another search</P><P>&nbsp;</P><LI-CODE lang="markup">search 2 [search 1]</LI-CODE><P>&nbsp;</P><P>Search 1 would return the import/ export countries of the top 100 selling fruits, which are then used as part of the filter for search 2. In search 1 you can sort then truncate the results using head 100.</P> Tue, 31 Aug 2021 08:33:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-the-result-from-one-function-into-another-function/m-p/565292#M196949 ITWhisperer 2021-08-31T08:33:23Z