I have loaded table files (CSV) into qlikview. There are fields in the table, CARD USERNAME and DATE & TIME. The records in this table represent the user (CARD USERNAME) who tapped their passes into the door entrance system and the date time stamp (DATE & TIME). So there can be several instances of CARD USERNAME in the table, each wil just have different DATE & TIME.
By the way, I am using personal edition.
Below is my code
LOAD Sequence,
[Date and Time],
[Card user name],
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
When I create tablebox and added all fields, it simply list all instances of CARD USERNAME and DATE & TIME.
Question;
What do Ineed to do so that the table will only show one instance CARD USERNAME with the corresponding DATE & TIME and the criteria being that the DATE & TIME to be used is the latest one.
