|
 Posted 5/15/2007 12:26:19 PM |
| | | I am currently mapping from one version of CRM into another version which has a bit more customisation. I need to be able to map between a picklist in the source data and one in the destination, can anyone help please? I can not see anywhere where it allows this or does it do it automagically in the background. Any help appreciated. Thanks Cookie |
| | Posted 5/16/2007 8:15:42 PM |
| | Import Manager does not have a feature that allows you to map values in your source to other values in the destination. However, assuming you used a SQL data type as your source, you can certainly write the appropriate SQL query to achieve the same goal. Your SQL query can contain a "CASE ... WHEN ... ELSE ... END" which allows you to build logic such as:SELECT CASE SourceField WHEN "Old Value" THEN "New Value" ELSE SourceField END FROM MyTable
|
| |
|