3 Replies Latest reply on Apr 2, 2021 7:19 AM by Andrea Picasso

    Setting default value when lookup is returning no data

    Nihar BHATT Active Member

      I am using Informatica CDI Tool in which we had designed the Data Synchronization Task to migrate data from source to destination.

       

      In Salesforce we are trying to migrate the Opportunity data with createdBy field (user lookup in salesforce) and in which we need to perform the lookup. Now, I would like to know whether it is possible to set the default return value if the lookup does not return any values in a record? (See the attachment)

       

      Expression for lookup is as follows

       

      IIF(ISNULL($OutputField),'0057g000004nD2DAAU',$OutputField)

       

      if $OutputField is null then use the default value 0057g000004nD2DAAU or else return the value of lookup result