Data Modeling Issue

[#1]

Hi Friends,

I got an issue while loading data,I have two tables,where I have to merge the tables,when I just load those tables I got following table

which give me correct total that is 130

but when I used apply map output table is

which give correct total i.e. 130 but EMP P is missing because of many to one relationship.

and when I used join the output table is like

which give 160 which is not correct.

Please anyone has any suggestion please share here

please find sample application and data file in attachment

[#2]

thank you all for your valuable comment

[#3]

thank you sumita it works..