Is there a way to replace the null values with the cell values from above in Data Jobs (e.g. first null with 01/01/2016)? I was thinking about the Window Lag function. However, this function seems not to be supported in Data Jobs (SQL Vertica).
Page 1 / 1
Celonis EMS uses a version of SQL Vertica. Can you try LAG function?
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Analytic/LAGAnalytic.htm#:~:text=Returns%20the%20value%20of%20the,rows%20can%20be%20reliably%20known.
You can use the LAG-Function.
You can go through Date with a CASE WHEN and if it's null it should set it to LAG(DATE)
Look it up here:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.