values equal to previous period

[yelin_nyu]

the inventory data is full of holes, in order to fill in those holes, i have to say if len(onhand)=0, onhand=onhand of previous day for this item at this store. how do i put that in the script?

Thanks

[MayilVahanan · Accepted solution]

HI

Try like this

Load *, if(Len(Onhand)=0, previous(Onhand), Onhand) as onHand

from datasource order by primaryfieldname, datefield asc;

Hope it helps