The Field List is used to specify the mapping between the source table and the destination table.

The easiest way to specify a field, is to start writing the name or part of the name of the field. The automatic field lookup feature will try to find the field that you are looking for - it will show you a list of matching fields that you can choose from.

When editing the Field List there is one important thing to note: You can either select a field from the popup list, which will automatically save the selected field; Or you can enter the field name or formula directly, In which case you have to save the entry manually by pressing the green ok-sign at the end of the edit field.

You can use Formulas in the left side (Source field) to manipulate data during the transfer. All formulas must start with two hashes - like ##

If you need to use the same field as source more than once, please specify it as a formula the second time - like ##"FIELD"

In the destination field, you cannot specify the same field twice. If a field should be set to different values depending on some condition, please use a formula to calculate the field.

There is a couple of links below the Field List that can help you get the Field List populated faster:

Delete Fieldlist:

Deletes the entire Fieldlist.

Build new Fieldlist:

All the fields common in source and destination will be mapped automatically in the "Source Field" column and the "Destination Field" column.

Build Fieldlist from source:
All the fields in the source table will be listed automatically in the "Source Field" column.
If the destination table contains a field named identical to a field in the source table, it will be listed in the destination field.

Build Fieldlist from destination:
All the fields in the destination table will be listed automatically in the "Destination Field" column.
If the source table contains a field named identical to a field in the destination table, it will be listed in the source field.

Formulas

In the bottom of the window, you can unfold a list of all the fields in the source table and in the destination table respectively.