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).
Question
Replacing null values in column with value from cell above in Data Jobs
+6
+2Celonis 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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.