02-22-2021 05:34 AM
I’m building a pipeline to copy data from CRM to another database
In the CRM table there is an integer value that is a foreign key to another table (StringMapBase)
I’m using a CRM Search to get the data, but this is bringing over the label from SMB, not the integer value, and I need the integer value for the destination table.
is their any way in the mapper to say you want the actual value in the database table rather than the friendly value?
Thanks