Partial Reload!?

Thu, 14 Mar 2013 11:58:49 GMT

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;

topic Partial Reload!? in QlikView

Partial Reload!?