Restrict Case sensitive entries in transform map

[Ram141]

Hello All,

As shown below for the same serial number record multiple entries got created and we could see 'Name' is in Captial for record and small case for one record.

And in transform map we have given coalesce on Serial Number but still it allowed duplicate entries as shown below.

Please help us to rectify this and to restrict duplicate entries.

Thanks,

[Gunjan Kiratkar]

Hi @Ram141 ,

You can make use of coalesce case sensitive as below and make them true. Click on gear icon.

[Ram141]

Hi Gunjan,

Thanks for your quick response.

I could see coalesce case sensitive  is marked as False, I have to set this to  True correct?

And also here Name is having case sensitive entries not Serial Number do I need to add 'Name' to coalesce.

Thanks,

Ram 

[Gunjan Kiratkar · Accepted solution]

Hi @Ram141 ,

Yes mark it as true.

Only mark Name as coalesce case sensitive and check for 2-3 records initially.