Lookup -it is not working

[#1]

I have data looks like below

Document	Item	Material	StartDate
8910023489	0	-	1/1/2009
8910023489	10	xx1	-
8910023489	20	xx2	1/2/2009
8910023489	21	xx3	-
8910023489	30	xx1	-
8910023489	40	xx2	-
8910023489	41	xx3	-

If the Startdate has a value null -I have to pickup the startdate value which is posted on the item level 0 and update the value

of startdate for line item 10,21,20,40,41.(it is huge amount of data)

I tried with lookup didn't worrk.

advance thanks for your help on this issue

[martin59]

Hi,

You could use the peek() function

LOAD *,
if(isnull(StartDate),peek(StartDate,-1),StartDate) as NewStartDate;
LOAD...
FROM...;

Is that you want ?

Martin

[#3]

Problem is fixed . Thanks for support.Apply map worked for this scenario.