Need some advice on how best to set up data loading for my app. I have 2 Excel files that are generated each day. One is a list of patients seen in the ED. The other is a list of floors where patients are admitted to. Each report has an ID number that is unique to the ED visit.
When I first set up the app, I loaded patient list data for several days from an XLS file that had multiple tabs. Since then I've just been loading the new daily file. Everything seems to be working smoothly.
My original plan was to just keep loading the new daily reports. I ran into trouble when I tried to do a left join in order to add the admission location to the patient list data. Is it better to set up an association based on the unique identifier field? Is there a better way to accomplish this?