Hi,

Actually, i use the function merge like this:

(Data1 <- Data1[1:7,1:3])
  Policy.Number AXA.Entity Country
1    1060000077        BNL     BNL
2       4001023         CH     BNL
3    1060000006         UK     BNL
4       4001025         CH     BNL
5      6.00E+13        USA     BNL
6       6100001         UK     BNL
7       4001028        USA     BNL
> Data2 <- read.csv2("c:/GWPMax1.csv",sep=",")
> (Data2 <- Data2[1:7,1:2])
  Policy.Number  GWP_Max
1       4001023   500.00
2       4001024 10593.54
3       4001025   700.00
4       4001026     0.00
5       4001027  3621.25
6       4001028   600.00
7       4001029  7588.27
> (m <- merge(Data1,Data2, by.x = "Policy.Number",by.y = "Policy.Number"))
  Policy.Number AXA.Entity Country GWP_Max
1       4001023         CH     BNL  500.00
2       4001025         CH     BNL  700.00
3       4001028        USA     BNL  600.00

i need the number of records not matching between the two original data bases.

Can you help me please?

thank you a lot!!


      
	[[alternative HTML version deleted]]


