Hello,
I have a Core table with fields: Key1, Key2, A, B, C, D, ...
I have multiple 'update' files with varying fields that all are present on the Core table, all with one of several key fields that are also present on the Core table. Some examples:
Example 1: Key1, C,D,X
Example 2: Key2, A, B, J, K, Z
Each update file has a list of values under the field names that need updating in the Core table where the Key of the Update file corresponds to one of the keys in the Core table.
I can import the various update files with wild cards; I have imported the Core table too.
How can I automatically 'map' the given key field and the variable number of fields/columns in the Update files to update to their corresponding field/column names in the Core table?
Ideally I would like to save and mark as 'superseded' the original record in the Core table and append the updated record marked as 'new' and adding the file name of the relevant update table.
Many thanks.
Kieran
