MyRapidi
MyRapidi
Menu

Search our Wiki

Conversions (list of from-to values to convert)

Overview

  • With "Conversions", you can convert the value of a field during the data transfer.
  • This is good if you have a smaller set of values in the source database that needs to be converted to another set of values in the destination database.
  • For example you could have department codes "A", "B" and "C" in the source and in the destination these needs to be "EAST", "WEST" and "SOUTH".
  • Another way to achieve the same would be to use the formula CASE or CONVERT directly in the Field List ( mapping) section.
  • If you have another table that contains the mapping between the source values and the destination values, you could also use the formula DBLOOKUP in the Field List to lookup the corresponding destination value.
  • Conversions will always be done on the source table - data is converted when it is read from the source table.
  • Conversions are not done when the field is used in a formula in the Field List. In this situation, you should use the CASE formula instead. 

 

  1. Field Name:

    2. Here you specify the field name from your source system that should be converted.

     

  2. From Value:

    3. Here you specify the value from the source table.

     

  3. To Value:

    4. Here you specify the corresponding "to value" (the value you would like to see in the destination table).