Need Help

[gireesh1216]

Hello Team,

Please help me on below scenario. 

we have raw data like below:

ID	NAME	D	STATUS
1216	GIREESH	D1	PASS
1216	GIREESH	D2
1216	GIREESH	D3
1216	GIREESH	D4
1217	NARESH		FAIL
1217	NARESH	D5
1217	NARESH	D6
1217	NARESH	D7

Result: Need STATUS as New Status column if ID and NAME is same.

ID	NAME	D	STATUS	New Status
1216	GIREESH	D1	PASS	PASS
1216	GIREESH	D2		PASS
1216	GIREESH	D3		PASS
1216	GIREESH	D4		PASS
1217	NARESH		FAIL	FAIL
1217	NARESH	D5		FAIL
1217	NARESH	D6		FAIL
1217	NARESH	D7		FAIL

[Anil_Babu_Samineni · Accepted solution]

Don't create Dump

If(ID&NAME=Previous(ID&NAME), peek('New_Status'), STATUS) as New_Status