We have a query where we need the EndDate to be the StartDate of the previous entry for all particular values in a row
| autoregress StartDate as p_StartDate
| eval EndDate=if(EndDate!="",EndDate,p_StartDate)
i want like End date will be next Start date and also
Startdate Endate
10-02-2019 07-07-2020
07-07-2020 "blank "
blank indicates it is running
your sample is too little.
please show the table what you want.