You can export a lookup table, download and modify the file, and then re-import it.
To export a lookup table, you need the Manage Reference Data feature privilege. For more information about feature privileges, see the Introduction and Getting Started help.
1In Metadata Command Center, go to the Explore page.
2Click the menu on the top of the page and select Lookup Tables.
On this page, you can browse through all published and unpublished lookup tables and view basic information about each table.
3Hover your mouse over the lookup table that you want to export, and click the Action menu.
4Select Export.
A job starts to export the lookup table. You can monitor the status of the job on the Overview page. If the publishing is successful, the job status changes to Published and the last job status changes to Completed. You can see the top 20 sample values of the lookup table when the job completes.
You can also click Export on the lookup table page.
5Click Download Export File in the Job Details area to download the CSV file.
6Optionally, curate the downloaded file based on business needs and re-import the file.