Six versions of student financial aid web forms are filled out and signed by up to 5 people. The names of the fields were automatically named as User field 1, User field 2 and and so on but were later renamed to better indicate their content, after some of the forms were already in process. These forms have up to 75 fields. The data from the forms needs to be exported to feed another system. The problem is that some data fields have the original field names and others the newer names. When they are exported each version of the name goes into a separate column and everything is sorted alphabetically. In addition, the data entered by each participant goes in a different line in the data file. Needless to say, it is tough to determine what columns make up the data from one form. The agreementId value identifies a form, but up to 5 lines share that same value and have data in different columns. Can all the data be re-exported with the current field names to obtain consistent columns?
AdChoices