M
mralmackay
Trying to do some data mapping of user information from our old system
to our new one.
Structure:
1 Main Tables (old system)
- UserFunctionLocation
(Contains 3 fields: UserID; Function; Location)
2 Conversion Tables
- ConversionFunct
(Contains 2 fields: OldFunction; New Function)
- ConversionLocation
(Contains 2 fields: OldLocation; New Location)
Need a query that converts entries within Table 1 (Function and
Location fields) to be as per the Conversion table fields. I can do
this when it's just one on one mapping by linking the tables, however
this will mean that if there's no conversion option these records
don't appear. I'd like it if the above could happen for every user,
however if there is no conversion possible the function or location is
just left blank. If possible I would then also like a separate output
of these entries as well, however this is not essential as I can
download and compare where entries are blank through excel.
Appreciate your help, Thanks Al.
to our new one.
Structure:
1 Main Tables (old system)
- UserFunctionLocation
(Contains 3 fields: UserID; Function; Location)
2 Conversion Tables
- ConversionFunct
(Contains 2 fields: OldFunction; New Function)
- ConversionLocation
(Contains 2 fields: OldLocation; New Location)
Need a query that converts entries within Table 1 (Function and
Location fields) to be as per the Conversion table fields. I can do
this when it's just one on one mapping by linking the tables, however
this will mean that if there's no conversion option these records
don't appear. I'd like it if the above could happen for every user,
however if there is no conversion possible the function or location is
just left blank. If possible I would then also like a separate output
of these entries as well, however this is not essential as I can
download and compare where entries are blank through excel.
Appreciate your help, Thanks Al.