Hey peoples
I am working on a new asset system implementation, migrating data from legacy system to the new system. Some of the field names are different in the legacy system to the new system. Is there any kind of mapping functionality in excel where I extract the data from the legacy system and can auto populate the upload template for the new system. The number of columns vary between the legacy system and new system. An example of what I want to do:
Legacy System Field Name New System Field Name
Infrastructure_Number External_ID
Street_Name Location
Pipe_Length Length_of_pipe
Rather than copying and pasting data from one worksheet to another, I want to define the mapping and auto populate upload template for new system
Thanks in advance
GT
I am working on a new asset system implementation, migrating data from legacy system to the new system. Some of the field names are different in the legacy system to the new system. Is there any kind of mapping functionality in excel where I extract the data from the legacy system and can auto populate the upload template for the new system. The number of columns vary between the legacy system and new system. An example of what I want to do:
Legacy System Field Name New System Field Name
Infrastructure_Number External_ID
Street_Name Location
Pipe_Length Length_of_pipe
Rather than copying and pasting data from one worksheet to another, I want to define the mapping and auto populate upload template for new system
Thanks in advance
GT