parsing data on load

[#1]

Here is my question, I will explain the data I have in a csv file. The File is a log of user id and their login dates, so for one user I may have multiple login dates. Is there a way that on loading the csv it loads only the user id and their latest login date? I am not interested in prior dates, just the latest one.

Many thanks for your help.

regards,

Roberto

[deepakk · Accepted solution]

HI Roberto,

You an try out the below code.

Load user,

max(Date) as date

from User.xls group by user;

I hope this helps.

deepak