previous date

[shravanveer]

hi, 

 IF(IsNull(DATE), Previous(DATE), DATE) AS DATE it has been working for one empty  field  ,and i need same script for more empty fileds on the same table  like shown table

ID	DATE
100	12-06-2022
101	13-06-2022
102
103	15-06-2022
104
105
106	19-06-2022

[abhijitnalekar]

Hi @shravanveer,

Please use below script

load*,
if(
len(trim(DATE))>0,DATE,
if(len(trim(DATE))=0 and len(peek(DATE))=0,
previous(Previous(DATE)),peek(DATE)
))as Datenew,

;

load *inline
[
ID,DATE
100,12-06-2022
101,13-06-2022
102,
103,15-06-2022
104,
105,
106,19-06-2022
];