JeffCarlson1
2 years agoQrew Member
File Import: Mapping one source field to multiple existing fields
I am wondering how to map one field from a source file to more than one existing fields when performing a file import. As an example, I might have "Customer Name" as a field in my file that I am importing into a table. The existing table may have both fields "Customer Name" and "Customer ID." In this case, I want to be able to map the "Customer Name" from my file into both the "Customer Name" and "Customer ID" fields during the import.
Is this possible without modifying my source file to make an additional field that is a copy of the customer names prior to import?
------------------------------
Jeff Carlson
------------------------------