topic Re: Interval Match Based On Dates in Talend Studio

Interval Match Based On Dates

Anonymous — Tue, 04 Jun 2019 12:29:49 GMT

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.

Re: Interval Match Based On Dates

Anonymous — Tue, 04 Jun 2019 15:29:19 GMT

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

hope this will help

Re: Interval Match Based On Dates

Anonymous — Wed, 05 Jun 2019 06:43:50 GMT

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,

Re: Interval Match Based On Dates

Anonymous — Wed, 05 Jun 2019 16:34:02 GMT

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

Re: Interval Match Based On Dates

David_Beaty — Tue, 25 Jun 2019 20:53:11 GMT

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.