Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: parsing data on load

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

1 Reply
deepakk
Not applicable

Re: parsing data on load

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