Load only one entry for each record

[robert99]

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 · Accepted solution]

OK I CAN TRY THIS

http://community.qlik.com/message/425760#425760

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;