Mapping Load CLAIM_N0, SALVAGE From e:\SALVAGE.qvd
(qvd) ;
ALL:
Load *,
ApplyMap(' Mapsalvage',CLAIM_NO, null()) as SALVAGE
Resident MC;
DROP TABLE MC;
I have above syntax which is running well. But In MC table there are some times more than one records with the same CLAIM_NO and when the above script is run SALVAGE amount is recorded against all such records duplicating the SALVAGE amount. I want to record salvage amount only against distinct CLAIM_NO. How can restrict such a thing through apply map. Pls help
