topic Load only one entry for each record in QlikView

Load only one entry for each record

robert99 — Sun, 26 Jan 2014 02:23:24 GMT

I have a file that contain more than one entry for each call

Call Date

101 1/1/2014

101 2/1/2014

101 3/1/2014

102 2/1/2014

102 5/1/2014

I want to load only the last date for each call

What is the best way to do this

Thanks for any help

robert99 — Sun, 26 Jan 2014 02:42:27 GMT

OK I CAN TRY THIS

Maybe like this:

INPUT:

LOAD

Call,

Date

FROM

[C;

CURRENT:

LOAD lead_id,

max(date) as LastUpdate

RESIDENT INPUT GROUP BY Call;

DROP TABLE INPUT;