Skipping records where users do not exist

[samadam]

I am trying to import data into custom tables with users fields. Some of the users do not exist in the target system. IS there a way to skip these records? or do I have to check in the transform map script to validate?

[Jaspal Singh]

Hi Sam,

You can check & make User Name for any other field coalesced & then try to update it. If no record exists you can use choice action on transform map as ignore.

[nitin_kumar · Accepted solution]

Hi Sam,

If you want to skip the whole row if the user doesn't exist, on the field map where you are mapping the User field set 'Choice action' as 'Reject'. This will reject the rows for which no user data is available.

Create a field map

Thanks,

Nitin.

Hit Like, Helpful or Correct based on the impact of the response

[samadam]

Thank you