topic Re: tMap comparison of two Dates in Talend Studio

tMap comparison of two Dates

Anonymous — Tue, 31 May 2016 18:20:25 GMT

Hello Talend community ,

i am new on talend and i have this problem ,

I am using a tMap between two tables (Table 1 and Table 2 )
i am using and ID ti join between the two table table1.id=table2.id

But i need to add a condition on a Date , the condition is table1.date > table2.date ,
but when i write it like this (see picture ) on tmap it gives me an error , can someone help me please

Re: tMap comparison of two Dates

Anonymous — Wed, 01 Jun 2016 04:16:43 GMT

Hi,
You can not compare date directly in tMap.
Here is a built-in method for comparing date in talend. TalendDate.compareDate(Date date1, Date date2) which return to Integer.
The result wheather two date is the same, if first one less than second one return number -1, equlas return number 0, bigger than return number 1
Please take a look at my screenshot.
Best regards
Sabrina

Re: tMap comparison of two Dates

krengan21 — Thu, 16 Feb 2017 14:34:00 GMT

Hi sabrina,

After comparing both dates if the date table [T1] is greater than table[T2} ie we will be getting the integer value as 1 ,How to process the data after the date present in the table [T2] what condition should be written to process the data after comparing the date values to process the data greater than the data in table [T2].Where i can write a if else statement to process data