Advice on Target Lookup Fields

  • 17Views
  • Last Post 2 weeks ago
0
votes
Ben Willis posted this 3 weeks ago

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
0
votes
Simon Bubnov posted this 2 weeks ago

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.

0
votes
Ben Willis posted this 2 weeks ago

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

Close