We have a requirement to write data to flat files.the challenge we are facing here is to transpose rows to columns when data not available .below is the scenario.
we have the below table strucutre and while writing to the flat file we need to creted 12 columns for each emp if irrespective of if he is got data or not(i.e only jan and mar is acilable in table but we need to show all months with blank data )
Below is the result required in Flat fie.Mainframe system is expecting result in this format .could you please suggest the best method to achieve this or any articles on this
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.