My company has a process to update information in our system based on data received in Excel files received from various suppliers. These files arrive to us in multiple formats but the process remains the same for each.
Each file will have a reference ID, a vehicle registration number and a cost amount to update in our system but different files may call these different things for example, file A has the cost under a column called “Cost” but file B calls this column “Total” and it may appear in a different column.
My question is - what would the best practice be to process these files and tell the RPA that for the amount, it needs to look at “Cost” in file A but “Total” in file B? The same applies for the other fields - Reference ID and Registration.
We expect to receive new file formats in the future which will need to be added to this process with little/no extra development.
Hope this makes sense!