i have lookup like following :
ID jobname start_time end_time frequency
1 abc 0:00 21:00 60
2 def 3:00 4:00 10
.....
.
.
.
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)
similarly, def row should repeat for 10 times (i.e. 3:10, 3:20, 3:30,....4:00)
is there any SPL command to populate the lookup like this ?
Thanks.
@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?
What is the expectation/format of the final output to be uploaded to the lookup file?