https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477239#M133941 <P><A href="https://www.splunk.com/en_us/blog/tips-and-tricks/splunk-rest-api-is-easy-to-use.html">https://www.splunk.com/en_us/blog/tips-and-tricks/splunk-rest-api-is-easy-to-use.html</A><BR /> try and make cron</P> Fri, 17 Apr 2020 12:44:21 GMT to4kawa 2020-04-17T12:44:21Z https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477238#M133940 <P>I just want to create csv file automatically everyday</P> <P>for example, today just is created 20200417.csv<BR /> tomorrow will be created 20200418.csv ...</P> <P>Is it possible??</P> Fri, 17 Apr 2020 11:20:22 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477238#M133940 tkdguq0110 2020-04-17T11:20:22Z https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477239#M133941 <P><A href="https://www.splunk.com/en_us/blog/tips-and-tricks/splunk-rest-api-is-easy-to-use.html">https://www.splunk.com/en_us/blog/tips-and-tricks/splunk-rest-api-is-easy-to-use.html</A><BR /> try and make cron</P> Fri, 17 Apr 2020 12:44:21 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477239#M133941 to4kawa 2020-04-17T12:44:21Z https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477240#M133942 <P>You can use <CODE>map</CODE> command and get the data in csv using below query. You can <CODE>append</CODE> OR <CODE>join</CODE> below query with your main search.</P> <PRE><CODE>| makeresults | eval date = strftime(now(), "%Y%m%d") | map search="| inputlookup $date$.csv" </CODE></PRE> Fri, 17 Apr 2020 12:47:41 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477240#M133942 manjunathmeti 2020-04-17T12:47:41Z https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477241#M133943 <P>thanks for your help!</P> Sun, 19 Apr 2020 10:21:33 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477241#M133943 tkdguq0110 2020-04-19T10:21:33Z https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477242#M133944 <P>thanks for your help! </P> Sun, 19 Apr 2020 10:21:54 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-create-lookup-table-file-csv-file-automatically/m-p/477242#M133944 tkdguq0110 2020-04-19T10:21:54Z