Populate 'Null' values with previous known 'not null' value

ArunselvanJun 9 2014 — edited Jun 9 2014

Hi All,

I have the following requirement to populate the missing values (null values) with the available previous known 'Not null' values.

Example Source:

Emp_Id	Start_Dt	LOC	Comm	Grade
A101	1/1/2013	NJ	4000	B
A101	3/15/2013	CA	4800
A101	5/15/2013		3500	C
A101	7/25/2013		2500
A101	12/20/2013	NY	5800	A
A101	2/14/2013		5000
A101	5/20/2014	DC	6000	A
A101	6/3/2014		3600	C
A102	5/24/2013	LA	5000	A
A102	12/15/2013		4300

Expected output values in LOC and Grade columns:

Emp_Id	Start_Dt	LOC	Comm	Grade
A101	1/1/2013	NJ	4000	B
A101	3/15/2013	CA	4800	B
A101	5/15/2013	CA	3500	C
A101	7/25/2013	CA	2500	C
A101	12/20/2013	NY	5800	A
A101	2/14/2013	NY	5000	A
A101	5/20/2014	DC	6000	A
A101	6/3/2014	DC	3600	C
A102	5/24/2013	LA	5000	A
A102	12/15/2013	LA	4300	A

Any suggestion would be helpful.

Regards,

Arun

This post has been answered by Martin Preiss on Jun 9 2014

Locked Post

New comments cannot be posted to this locked post.

Locked due to inactivity on Jul 7 2014

Added on Jun 9 2014

5 comments

2,152 views