script for applymap to get first row

[#1]

HI,

When I am doing apply map in script side then there are multiple records against one value but I want to do first row mapping and get value against that. So how to write script for that.Administrator

[#2]

I suggest you make sure there are only one possible matching field by loading only unique key fields in your mapping table.

[#3]

Hi Pankaj,

You should implement it in your mapping load. Group by the ID to obtain an unique value for each one. These are some options...

• Máx or Min Value.
• Rank by number of rows and select the most common value.
• Take the value of the first record for each ID using the rownum() function.