MS Access - Muti-column lookup and replace
Posted on 2017-12-07
Hello, and thank you for your help.
I am moving data from one system to another. As part of the move I want to change some of the data in a couple of fields - "Issue" & "Sub-Issue".
My output will be a query combining data from a couple of different tables, that I will export to CSV for import into the new system.
I do not like the categories used in the old system for Issue & Sub Issue and wish to change them prior to import.
I have a table that, I am in the process of building, that will consist of - Old Issue | Old Sub-Issue | New Issue | New Sub-Issue
I do not care if the proposed solution does either;
1) Changes the values in the original table OR
2) Does the mapping/changes when the final query is run prior to export.
So how can I have the 'system' lookup and find a match for the two 'Old' fields and them change them to the 'New' values
I hope this all makes sense.
More Info - Table that has the 'Issue' and 'Sub-Issue' fields - 'Tickets'
- Table that will have the Old New Mappings - 'Issues'