Could you please help me, how to make a complex join in Talend
My requirement is as below:
table1.invoice_date between table2.start_date and table2.end_Date
table1.pk = table2.fk
Could you please try the below method?
The date expression used in the output expression column is as shown below.
TalendDate.compareDate(row1.invoice_date,row2.start_date)>=0 && TalendDate.compareDate(row1.invoice_date,row2.end_date)<=0
Hope I have answered your query. Please spare a second to mark the topic as resolved :-)
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)
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