Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;