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.
you can read the two files and use tmap to perform the join
hope this will help
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
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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