Interval Match Based On Dates

Highlighted
Six Stars

Interval Match Based On Dates

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. 

 

proj_lob.png

Nine Stars

Re: Interval Match Based On Dates

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

 

tmap joins job.PNGtmp joint configuration.PNG

 

hope this will help

 

Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Interval Match Based On Dates

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,

Nine Stars

Re: Interval Match Based On Dates

Sorry, I don't know how to do a join with between on tmap
Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Nine Stars

Re: Interval Match Based On Dates

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.

 

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog