I want to calculate previous date for that workcenter for that functional location in script side and if no date then it should be blank.
I have attached sample file for that, in that Output column is my expected ooutput admin
Load *,If(RowNo() > 1 And Previous([Work Center]) = [Work Center],Previous(Date)) As Output1;
LOAD [Work Center],
(ooxml, embedded labels, table is Sheet1);
Retrieving data ...