Find Text Give output for next all rows

[rajeshqvd]

Hi Need below Output field need to do in Script please help on this if Name = jone after row will return same name until ID<>Previous(ID)

ID	Name	OUT PUT
111	lee
111	assds
111	jone	jone
111	ssds	jone
111	sdd	jone
111	sdsas	jone
111	sasww	jone
222	eeee
222	sdsd
222	jone	jone
222	ddsd	jone
222	sddd	jone

[tresesco · Accepted solution]

Try:

Load *,
	If(ID =Peek(ID), if( Name='jone', 'jone', Peek(Output))) as Output