https://community.splunk.com/t5/Splunk-Search/SPL-command-to-copy-paste-rows-in-lookup-with-increment-values/m-p/452745#M128188 <P>@gowtham495, what is the current query you are using? Please elaborate your requirement. Is the current output 2 rows from where you need to generate 21 rows for first and 10 rows for second?</P> <P>What is the expectation/format of the final output to be uploaded to the lookup file?</P> Fri, 22 Mar 2019 08:32:57 GMT niketn 2019-03-22T08:32:57Z https://community.splunk.com/t5/Splunk-Search/SPL-command-to-copy-paste-rows-in-lookup-with-increment-values/m-p/452744#M128187 <P>i have lookup like following :</P> <P>ID jobname start_time end_time frequency<BR /> 1 abc 0:00 21:00 60<BR /> 2 def 3:00 4:00 10<BR /> .....<BR /> .<BR /> .<BR /> .</P> <P>i need to populate the lookup in such a way that i should have my 1st row repeated 21 times (i.e no of times the job gets repeated between the start time and end time, having 60 minutes of frequency) <BR /> similarly, def row should repeat for 10 times (i.e. 3:10, 3:20, 3:30,....4:00)<BR /> is there any SPL command to populate the lookup like this ?</P> <P>Thanks.</P> Tue, 29 Sep 2020 23:47:15 GMT https://community.splunk.com/t5/Splunk-Search/SPL-command-to-copy-paste-rows-in-lookup-with-increment-values/m-p/452744#M128187 gowtham495 2020-09-29T23:47:15Z https://community.splunk.com/t5/Splunk-Search/SPL-command-to-copy-paste-rows-in-lookup-with-increment-values/m-p/452745#M128188 <P>@gowtham495, what is the current query you are using? Please elaborate your requirement. Is the current output 2 rows from where you need to generate 21 rows for first and 10 rows for second?</P> <P>What is the expectation/format of the final output to be uploaded to the lookup file?</P> Fri, 22 Mar 2019 08:32:57 GMT https://community.splunk.com/t5/Splunk-Search/SPL-command-to-copy-paste-rows-in-lookup-with-increment-values/m-p/452745#M128188 niketn 2019-03-22T08:32:57Z