topic Re: minDate and maxDate on tmap filtering in Talend Studio

minDate and maxDate on tmap filtering

Anonymous — Fri, 09 Jan 2015 16:26:13 GMT

Hello,
I want to implement a where clause in tmap filtering rather than in the input component query. What i want to do is retrieve and load data based on the minimum and maximum load date for all records. tAggregateRow is not producing the desired result. Any suggestions?
Many thanks.

Re: minDate and maxDate on tmap filtering

Anonymous — Fri, 09 Jan 2015 16:34:11 GMT

what about tAggregateRow is not working?
are you using a Date datatype?

Re: minDate and maxDate on tmap filtering

Anonymous — Fri, 09 Jan 2015 16:46:05 GMT

what about tAggregateRow is not working?
are you using a Date datatype?

I wouldn't say tAggregateRow is not working but i'm not getting the results that i want. I am working with very unstructured data that needs creativity. Yes - the data type is "date"
What i want is pull all records for a specific date (MAX) even with duplicates where it does exist.
Snippet of the clause currently in the input component
WHERE \"Date\" = (SELECT MAX(\"Date\") FROM \"Data\")
AND EXTRACT (YEAR FROM \"Period\")= 2008
Second part implemented in tMap and works
(row1.Period != null && TalendDate.formatDate("yyyy",row1.Period).equals("2008"))