Import lookup table values
You can import a file to map the source and destination attributes values for a specific lookup table. Source attributes should not be duplicated. To do so, follow these steps:
- Click the Import button, the following window appears:
![](https://guides.trasix.one/wp-content/uploads/2022/06/import-file-1024x549.jpg)
- Click Select to browse for the file you want to import,
- Select the file then click Open, the name of the file you selected appears in its field, click Next, the following window appears:
![](https://guides.trasix.one/wp-content/uploads/2022/12/import-values-1-1024x536.jpg)
You can click Back to return to the previous window.
- Select the sheet you want from the dropdown list in case your Excel file contains more than one sheet,
- Click Next, the following window appears:
![](https://guides.trasix.one/wp-content/uploads/2022/12/mapping-values-1024x536.jpg)
- Select the column of the sheet that matches each field, you can search for the field you want using the search field, then click Next, the following window appears:
![](https://guides.trasix.one/wp-content/uploads/2021/09/filter-window-import-1024x566.jpg)
- Click the radio button next to the import method, either all rows or rows that match certain criteria, a validation window appears informing you if records are valid or not, if not, you need to fix the sheet then import the file again,
- Click Next, the following window appears:
![](https://guides.trasix.one/wp-content/uploads/2022/12/import-validation-1024x536.jpg)
- Click Next, the following window appears:
![](https://guides.trasix.one/wp-content/uploads/2022/06/information-window-1024x579.jpg)
- Click Submit, the progress is displayed,
- Wait until the job is finished, then refresh the page, the imported values are listed.
Notes:
- If changes are not reflected on the page, refresh the browser by pressing F5.
- If any of the records are invalid, you can skip them by clicking the checkbox next to Skip invalid rows as shown in the below example:
![](https://guides.trasix.one/wp-content/uploads/2022/06/get-results-1024x536.jpg)
The Next button is activated, and you can import the valid rows.