Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

parsing data on load

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

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

1 Reply
deepakk
Partner - Specialist III
Partner - Specialist III

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