auto increment Talend

[Reims]

Hi there,

So i a bit lost and don t really know how to hang up this one...

Consider that i have a 2 DB table in Talend, let say firstly
A table invoices_only which has as fields, the invoiceNummer and the authors like this

Then, a table invoices_table with the field (invoiceNummer, article, quantity and price) and for one invoice, I can have many articles, for example

and through a tmap want to obtain a table invoice_table_result, with new columns, one for the article position, an one other for the total price. for the position i know that i can use something like the Numeric.sequence("s1",1,1) function, but don t know how to restart my counter when a new invoices nummer is found, and of course for the total price it is just a basic multiplication

so my result should be some thing like this

Here is a draft of my talend job, i m doing a lookup on the invoicenummer between the table invoice_only and invoices

Any Advices? thanks.

[Anonymous]

Hello,

The screenshots you attached are not available in community. Could you please re-upload them into community?

For auto incremental load, we usually capture the changed data and only load these changed data into target table.

Here is CDC feature in talend, please refer to this documentation: TalendHelpCenter: CDC architectural overview

Best regards

Sabrina