Partial Reload!?

[#1]

Why does this script double DepartmentID2 after partial reload?

DepartmentID:

ADD LOAD employeeID AS trackemployeeid,

    EmpCost as trackempcost,

    DepartmentID as trackdepartmentid,

    InputSum_x0028_DepartmentIDSim_x0029_,

    timestamp,

    UserName

FROM D:\xxxxx\Desktop\*.xml (XmlSimple, Table is [StraightTableBox/DepartmentID]);





DepartmentID2:

REPLACE Load

trackemployeeid AS trackemployeeid2,

trackempcost AS trackempcost2,

trackdepartmentid AS trackdepartmentid2,

    InputSum_x0028_DepartmentIDSim_x0029_ AS InputSum_x0028_DepartmentIDSim_x0029_2,

    MIN(timestamp) as timestamp2

Resident

DepartmentID

Group By trackemployeeid,

trackempcost,

trackdepartmentid,

    InputSum_x0028_DepartmentIDSim_x0029_;

   

ADD JOIN LOAD UserName as UserName2,

timestamp AS timestamp2

Resident DepartmentID;



//drop table DepartmentID3;