Interval Match Based On Dates

[Anonymous]

Hi, I am new on Talend. We have a below requirement in our project. 

scenario- We have project LOB allocation in one table and we have invoice data on another table.

 I want to Match and get LOB and LOB percent for invoices based on invoice date.

The final output I need is 

Project ID -- Customer ID -- Invoice No -- invoice date -- Invoice amt -- LOB ID --LOB %

how can I implement this?

Thanks in advance. 

[Anonymous]

you can read the two files and use tmap to perform the join

hope this will help

[Anonymous]

Hi,

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 

and

table1.pk = table2.fk

Thanks,

[Anonymous]

Sorry, I don't know how to do a join with between on tmap

[David_Beaty]

Hi,

On part of the join criteria, connect up the bits that are direct 1 to 1 mapping but the the date join, click the filter button (arrow and plus) on the row2 table.

You'll also need to set the join model to all matches I think, and it also drops completely the rows that dont join to anything, which you'll need to capture and join back in to your main flow somehow.