How to insert only one record in target table using transform map

[sunil10]

Hi Everyone

I have a simple requirement i have a excel sheet(Attached) 38 rows. When i am importing the data through transform map i want only one record to be inserted whose total is maximum. Please help

[Tai Vu]

Hi @sunil10 

In your Excel file, If the record existence is determined by the File Name field, you can activate Coalesce for that field in the Field Map in your Transform Map.

Cheers,

Tai Vu

[sunil10]

Hi Timi, 

I tried making file name Coalesce but doesnt help

[Harish Bainsla]

hi check below video it will help you

https://youtu.be/CJMHSyeNAAQ?si=5qtXD21MGbzEUcdx

[Ankur Bawiskar]

@sunil10 

So why not filter the excel manually and keep only 1 row?

what's the point in sharing all the other rows?