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.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables