topic use pervious function in App Development

use pervious function

shravanveer — Sat, 11 Jun 2022 05:02:34 GMT

how to write script two or more empty date fields to be filled with PREVIOUS function for given table below,

Vegar — Sat, 11 Jun 2022 06:17:25 GMT

Try this

LOAD
ID,
If(len(DATE)>0,DATE,Peek('DATE')) as DATE
FROM Source
Order by ID;

Vegar — Sat, 11 Jun 2022 06:23:07 GMT

This can be a good read for understanding the difference between previous and peek.