TRANSPOSE ! is it possible?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Stop pushing, especially on weekends. People post as, if and when they can. If they feel like it. There is no compulsion.

Please document the specification for what has to occur - the target-from-source mappings, if you will - in English. (Doing so may even help you to an unassisted solution.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Post by karthi_gana »

I have used an existing subroutine (which i came to know today morning) to convert the above file in the below format.

712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-71"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-72"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-73"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-74"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-75"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-76"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-77"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-78"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-79"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-80"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-81"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-82"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-83"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-84"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-85"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-86"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-87"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-88"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-89"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-90"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-91"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-92"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-93"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-94"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-95"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-96"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-97"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-98"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-99"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-99"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-99"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-99"|N/A
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-99"|10.277
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-99"|-22.581
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-99"|-7.87
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-99"|-19.598
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-99"|26.875
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-99"|-15.271
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-99"|16.279
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-99"|-14
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-00"|-4.651
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-00"|60.976
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-00"|57.576
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-00"|-21.635
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-00"|-2.454
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-00"|20.755
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-00"|-21.875
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-00"|-12.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-00"|-40.458
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-00"|43.59
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-00"|-14.286
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-00"|-43.229
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-01"|35.78
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-01"|-31.081
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-01"|-15.196
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-01"|131.214
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-01"|-16.96
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-01"|-27.746
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-01"|-6.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-01"|-48.286
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-01"|3.801
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-01"|-22.823
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-01"|-1.724
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-01"|-17.193
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-02"|-38.983
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-02"|-16.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-02"|-8.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-02"|-31.818
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-02"|-78.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-02"|-6.25
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-02"|173.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-02"|-75.61
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-02"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-02"|70
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-02"|88.235
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-02"|56.25
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-03"|-20
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-03"|32.5
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-03"|-18.868
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-03"|-30.233
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-03"|16.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-03"|28.571
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-03"|11.111
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-03"|-10
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-03"|-22.222
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-03"|-14.286
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-03"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-03"|-40
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-04"|11.111
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-04"|75
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-04"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-04"|-28.571
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-04"|-24
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-04"|10.526
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-04"|19.048
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-04"|-36
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-04"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-04"|87.5
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-04"|-20
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-04"|-29.167
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-05"|5.882
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-05"|-50
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-05"|11.111
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-05"|-40
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-05"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-05"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-05"|-41.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-05"|-37.143
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-05"|-54.545
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-05"|700
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-05"|-62.5
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-05"|-46.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-06"|6.25
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-06"|5.882
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-06"|-11.111
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-06"|-6.25
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-06"|-13.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-06"|-23.077
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-06"|40
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-06"|-7.143
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-06"|-7.692
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-06"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-06"|-45.833
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-06"|-7.692
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-07"|66.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-07"|80
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-07"|11.111
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-07"|40
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-07"|185.714
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-07"|-25
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-07"|-50
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-07"|-33.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-07"|1
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-07"|147.525
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-07"|140
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-07"|-41.667
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-08"|28.571
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-29-08"|-22.222
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-08"|-14.286
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-08"|8.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-08"|-23.077
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-08"|-18
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-08"|-2.439
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-08"|22.5
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-08"|-69.388
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-08"|20
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-08"|172.222
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-08"|-65.306
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-09"|17.647
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-09"|25
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-09"|-40
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-09"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-09"|-33.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-09"|-40
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-09"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-09"|-5
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-09"|338.596
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-09"|-50.4
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-09"|-0.806
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-09"|46.341
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-10"|-44.444
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-10"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-10"|-10
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-10"|-10
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-10"|-55.556
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-10"|177.778
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"07-31-10"|-59
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"08-31-10"|90.244
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"09-30-10"|156.41
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"10-31-10"|-25
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"11-30-10"|-33.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"12-31-10"|-40
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"01-31-11"|50
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"02-28-11"|-55.556
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"03-31-11"|0
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"04-30-11"|-62.5
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"05-31-11"|53.333
712232|FR|ABC#(X(AB)~U$,1M)*1.000|12-31-71|06-30-11|M|475|"06-30-11"|4.348
Karthik
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Post by karthi_gana »

I am trying to transpose the above file into as below.

Asset_Code Yr Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
712232 1971 N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
..
..
..
712232 1999 N/A N/A N/A N/A 10.277 -22.581 -7.87 -19.598 26.875 -15.271 16.279 -14
..
..
..
712232 2011 50 -55.556 0 -62.5 53.333 4.348 N/A N/A NA/A N/A N/A N/A
Karthik
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Post by karthi_gana »

:roll:

Do i need to use PIVOT stage? I don't think so. Nothing is hitting in my mind. I don't have any idea from where to start. :(
Karthik
mobashshar
Participant
Posts: 91
Joined: Wed Apr 20, 2005 7:59 pm
Location: U.S.

Post by mobashshar »

Hi Karthi,
You have to use Vertical Pivot to get the desired result.

Using a transformer, strip out the Year value from your input file and create a Year Column and Pivot on Amount with Array Size 12 with Group By on Asset_Id and Year.

Also make sure to Sort the Input File on Asset_Id (Sorting and Partitioning) and Year (Sorting only)

Enjoy.

Mobashshar
Post Reply