Importing data for tabular mapping
Importing data from an existing file is a much faster way to enter large sets of data into the tabular mapping. First export the data from a two column Excel spreadsheet into tab-delimited format by choosing the File -> Save as… option in Excel and selecting the ‘Tab Delimited Text (txt)’ file format for importing.
In the eiConsole Data Mapper, create a tabular mapping. (See tutorial.) In the Tabular code mapping dialog click on the ‘Import’ button (marked with a file folder icon). Then choose which file to open and the mapping will be automatically populated with the file data.
If the mapping already contains some Source and Target values, when selecting to import it will asked whether to overwrite the existing data with our file or add to it.