I have two tables in two databases:
Now I want to compare the two dates ( TalendDate.compareDate(row1.date_maj, row2.DATE, "dd-MM-yyyy HH:mm:ss") )
If the resultat is -1 I get data1 and if the result 1 I get data2
Now the question is how to get data2 if there is no row in T1
and data1 if there is no data in T2
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema