Advice on Target Lookup Fields

  • 53Views
  • Last Post 03 July 2018
Ben Willis posted this 02 July 2018

Hey Support,

I am trying to find a way to do a Traget Lookup in an integrtation task where the two fields (source and target) are of two different types. I can't use the external Id mapping as I need to use the 'use first match when mutiple results'.

The target field is DT_WSTR and the source field is DT14. Is there anyway of achieving this?


Attached Files

Order By: Standard | Newest | Votes
Simon Bubnov posted this 03 July 2018

Unfortunately, it's not possible to compare fields of different types in a lookup. The types of the fields that are compared in a lookup must be the same.

We will investigate the possibility to support expressions in lookups and post here about the results. With expression you will be able to perform type conversions and cast the rsp_pid field to the DT_WSTR type. After this, you will be able to use lookup in the way you need, provided that ShelterBuddy_Id__c stores values similar to the rsp_pid values.

Ben Willis posted this 03 July 2018

Thanks for the info Simon. I had a feeling that would be the case.