transform data based upon columns and date

times29 · Post by **times29** » Tue Jul 16, 2013 3:58 pm

Hi,
How can i do below logic
Source data:
PERNER BEGDA ENDDA PERSG PERSK
00000351 19410130 19880303 1 12
00000351 19880304 19990627 6 65
00000351 19990628 99991231 5 50
00103016 19970421 20031015 A AA
00103016 20031016 20050619 A AA
00103016 20050620 20060521 A AA
00103016 20060522 20061116 A AA
00103016 20061117 20070408 A AA
00103016 20070409 20070415 A AA
00103016 20070416 20070930 B BA
00103016 20071001 20080413 B BA
00103016 20080414 20080414 A AA
00103016 20080415 20080615 A AA
00103016 20080616 20080616 A AA
00103016 20080617 20090913 A AA
00103016 20090914 20100826 A AA
00103016 20100827 20110330 A AA
00103016 20110331 99991231 A AA

Want it to transformer like below screen shot

Target data:

PERNER BEGDA ENDDA PERSG PERSK

00000351 19410130 19880303 1 12
00000351 19880304 19990627 6 65
00000351 19990628 99991231 5 50
00103016 19970421 20070415 A AA
00103016 20070416 20080413 B BA
00103016 20080414 99991231 A AA

chulett · Post by **chulett** » Tue Jul 16, 2013 4:15 pm

Start by spelling out your requirements - your transformation rules - in words.