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