Loading data using efffective date

Wed, 03 Sep 2014 07:44:58 GMT

Good day

I need assistance, I am trying to load data that has distinct values but I want to only load the most recent data of the employee using the last effective date.

Re: Loading data using efffective date

MK_QSL — Wed, 03 Sep 2014 08:39:19 GMT

Temp:

Load

EmployeeID,

Date([Effective Date]) as [Effective Date]

Inline

[

EmployeeID, Effective Date

A, 01/01/2014

B, 01/02/2014

A, 15/05/2014

B, 18/04/2014

C, 10/02/2014

A, 20/02/2014

];

Final:

Load

EmployeeID,

Date(Max([Effective Date])) as MaxDate

Resident Temp

Group By EmployeeID;

Drop Table Temp;

topic Loading data using efffective date in QlikView

Loading data using efffective date

Re: Loading data using efffective date