Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijay_K_N
Contributor
Contributor

duplicate minimum date field record

I have i/p like this

 

name,city,date
vijay,bangalore,05-09-1990
vijay,mumbai,06-09-1990
kumar,kolkata,12-11-1991
kumar,chennai,11-11-1991

 

i want o/p like duplicate minimum date field record 

 

vijay,bangalore,05-09-1990

kumar,chennai,11-11-1991

 

Labels (3)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

sort the data based on name and city and remove duplicate based on name in tuniquerows.

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

sort the data based on name and city and remove duplicate based on name in tuniquerows.

Vijay_K_N
Contributor
Contributor
Author

i/p data

 

 

name,city,date
vijay,bangalore,05-09-1990
vijay,mumbai,06-09-1990
kumar,kolkata,12-11-1991
kumar,chennai,11-11-1991
nanna,kolkata,01-08-2006
nanna,bihar,06-12-2004
nanna,mumbai,05-04-2005
nanna,delhi,09-03-2002

 

 

o/p will be like this minimum date fields

name,city,date

kumar,chennai,11-11-1991
nanna,bihar,09-03-2002
vijay,bangalore,05-09-1990

 

 

for ur logic wont work here 
name,city,date 
kumar,chennai,11-11-1991
nanna,bihar,06-12-2004
vijay,bangalore,05-09-1990

 

second row doesnt come minimum date

manodwhb
Champion II
Champion II

@lli ,as part of sort include date  and sort the required way to get the data.