MyRapidi
MyRapidi
Menu

Search our Wiki

Field List (mapping)

Overview


  • The Field List (mapping) is used to specify the mapping between the source table and the destination table.
  • The easiest way to specify a field, is to add the percent sign (%) and then 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 (mapping) there is one important thing to note: You can either select a field from the popup list or you can enter the field name or formula directly. The selected field will automatically be saved.
  • You can use Formulas on the left side (Source field) to manipulate data during the transfer. All formulas must start with two hashes - ##
  • 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 are a couple of links below the Field List that can help you get the Field List populated faster:




  • New : Click the 'New' button to create a new mapping line;
  • Delete Fieldlist: Deletes the entire mapping;
  • 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:
  1. All the fields in the source table will be listed automatically in the "Source Field" column.
  2. 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: 
  1. All the fields in the source table will be listed automatically in the "Source Field" column.
  2. 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:
  1. All the fields in the destination table will be listed automatically in the "Destination Field" column.
  2. If the source table contains a field named identical to a field in the destination table, it will be listed in the source field.
  • Browse Table Layout:
  1. Here you can browse the layout of all tables and fields in any of your Connections (provided that you have done a Read Design on the Connection first).
  2. When you click the button, a window opens up, and by default it will show the current Source Connection and Source Table on this transfer.
  3. You can then browse or search the fields, copy the fieldname or switch to another table or another Connection.
  4. When hovering over the fieldname a question mark (?) appears, click on the fieldname and it will 'copy to clipboard' for you to copy and paste it in easily.