topic parsing data on load in QlikView https://community.qlik.com/t5/QlikView/parsing-data-on-load/m-p/466453#M701065 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Many thanks for your help.</P><P></P><P>regards,</P><P></P><P>Roberto</P></BODY></HTML> Thu, 04 Oct 2012 10:28:14 GMT 2012-10-04T10:28:14Z parsing data on load https://community.qlik.com/t5/QlikView/parsing-data-on-load/m-p/466453#M701065 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Many thanks for your help.</P><P></P><P>regards,</P><P></P><P>Roberto</P></BODY></HTML> Thu, 04 Oct 2012 10:28:14 GMT https://community.qlik.com/t5/QlikView/parsing-data-on-load/m-p/466453#M701065 2012-10-04T10:28:14Z Re: parsing data on load https://community.qlik.com/t5/QlikView/parsing-data-on-load/m-p/466454#M701066 <HTML><HEAD></HEAD><BODY><P>HI Roberto,</P><P></P><P>You an try out the below code.</P><P></P><P></P><P>Load user,</P><P>max(Date) as date</P><P></P><P>from User.xls group by user;</P><P></P><P></P><P>I hope this helps.</P><P></P><P></P><P>deepak</P></BODY></HTML> Thu, 04 Oct 2012 10:41:13 GMT https://community.qlik.com/t5/QlikView/parsing-data-on-load/m-p/466454#M701066 deepakk 2012-10-04T10:41:13Z