I am working on an app for a company that has multiple programs that all run independently to each other. Each program uses there own database for their project info. I have been asked to take all of the data for all of the program and put them together so we can report on everything in one place. But the issue I am running into is that the programs all use numerical values for Project ID. So there is the chance that the program ID's will have duplicate entries from multiple programs.
I think that a simple solution would be to amend the data when the data is being uploaded so rather than having a numerical value for project id it would include a program identifier so that way I wont have an issue with duplicate ID's when I end up concatenating the data sets together.
Original Program ID: 12353
Amended Program ID: AZ-12353
Is this possible to do when uploading the data sets originally?