Resident Load Last Transaction & Corresponding Details

[#1]

Morning All,

I have an Excel table that I am trying to load into QlikView. It has the columns Date, Customer No., Balance On Act. and a number of other descriptive columns.

I am looking for assistance with a resident load which will pick 1. Distinct Customer number, 2. Last Date recorded, 3. Balance as at that date, i.e. the balance that corresponds with that date, and all other descriptive columns relating to that date.

Many thanks

H

[jagan · Accepted solution]

Hi,

Try like this

Data:

LOAD

*,

Date([Last Date]) AS DateFormatted

FROM DataSource;

INNER JOIN

LOAD

[Customer Number],

Date(Max(DateFormatted)) AS DateFormatted

RESIDENT Data

GROUP BY [Customer Number];

Hope this helps you.

Regards,

Jagan.

[#3]

Thanks Jagan,

Spot on, much appreciated.

H