1 / 6

Updateing a Master File from A Transaction File

Updateing a Master File from A Transaction File. By Daniel Gillo. First you need to sort the data. Transaction file. 113 – Clare +100. 127 – Anton +100. 098 – Ron +100. 115 – Johann +100. 096 – Ben +100. 160 – Daniel +300. 076 – Mrs. Janesko +100.

wilma-cortez
Download Presentation

Updateing a Master File from A Transaction File

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Updateing a Master File from A Transaction File By Daniel Gillo

  2. First you need to sort the data

  3. Transaction file 113 – Clare +100 127 – Anton +100 098 – Ron +100 115 – Johann +100 096 – Ben +100 160 – Daniel +300 076 – Mrs. Janesko +100

  4. To update the file you need to create a new master file and then write the infromation from the old master file with the updates from the transaction file to the new master file. Find the ifromation with the lowest key and write that infromation to the new file.

  5. Old Master File New Master File Transaction file 076 – Mrs. Janesko +100 076 – Mrs. Janesko 200 076 –Mrs. Janesko 300 096 – Ben +100 080 – Gillo 150 098 – Ron +100 090 – Bob 300 113 – Clare +100 096 – Ben 200 115 – Johann +100 096 – Ben 300 098 – Ron 200 127 – Anton +100 098 – Ron 300 160 – Daniel +300 100 – Dave 200 113 – Clare 200 113 – Claire 300 115 – Johann 200 115 – Johann 300 120 – Gerdrud 300 127 – Anton 200 127 – Anton 300

  6. New Master File 076 – Mrs. Janesko 300 080 – Gillo 150 090 – Bob 300 Done! 096 – Ben 300 098 – Ron 300 100 – Dave 200 113 – Claire 300 115 – Johann 300 120 – Gerdrud 300 127 – Anton 300 160 – Daniel 300

More Related