The exporting of lookups is very much like the export of an integration. Rather than going into the integrations part of the designer, you need to access the Lookups page. On this page, you will see the different lookups that have been created. You can then use the action menu icon to drop down the available options, which includes Export to CSV. Selecting this option will trigger the download of a comma-separated value file which will contain a line before the mapping values which match the column headers in the definition provided.

To demonstrate a change for the import process, select a lookup; for example, the one we created in Chapter 6, Creating Complex Transformations, and add an additional row of values to the end of the CSV.

Be careful when editing the CSV, particularly when using something like Excel as the editor, as it is possible to damage the file by accident. For example, changing the way the underlying operating system represents line termination. Between Linux...