Splunk Enterprise

We have a query where we need the EndDate to be the StartDate of the previous entry for all particular values in a row

shivareddysompa
Explorer

We have a query where we need the EndDate to be the StartDate of the previous entry for all particular values in a row

 

shivareddysompa_0-1593774776072.png

 

Labels (1)
Tags (1)
0 Karma

to4kawa
Ultra Champion

| autoregress StartDate as p_StartDate
| eval EndDate=if(EndDate!="",EndDate,p_StartDate)

0 Karma

shivareddysompa
Explorer

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

Tags (1)
0 Karma

to4kawa
Ultra Champion

your sample is too little.

please show the table what you want.

0 Karma
Get Updates on the Splunk Community!

New Case Study Shows the Value of Partnering with Splunk Academic Alliance

The University of Nevada, Las Vegas (UNLV) is another premier research institution helping to shape the next ...

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...