topic Re: duplicate minimum date field record in Talend Studio

duplicate minimum date field record

Vijay_K_N — Sat, 16 Nov 2024 02:41:36 GMT

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

Re: duplicate minimum date field record

manodwhb — Tue, 14 Apr 2020 11:18:01 GMT

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

Re: duplicate minimum date field record

Vijay_K_N — Tue, 14 Apr 2020 12:34:56 GMT

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

Re: duplicate minimum date field record

manodwhb — Tue, 14 Apr 2020 12:42:17 GMT

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