7.3.2 Exporting and Importing an Excel Sheet

While editing the Lookup Table definition, the process allows to export and import the Lookup Table data using excel sheets.

To export, click Export. This downloads an excel sheet with the lookup data. You can fill the data and then save the sheet. From the UI, you click Import and select the sheet from your local machine. This directly feeds the column details into the table and displays. While importing the data, you have an option to overwrite the existing data. If you select the checkbox and import, the system overwrites the existing data and writes the new data.

Searching the Column Values

To search the column value, click the funnel icon next to the column.

Figure 7-4 Lookup Table Data

Select any of the options from Like, Not Like, In, or Non In and enter the values in the text box below. This field accepts mutiple inputs. Click Search to fetch the details.