topic add rows after each rows in Talend Studio

add rows after each rows

FDufour1645879933 — Fri, 15 Nov 2024 22:58:23 GMT

Hello

I have a flat file of accounting entries that only has one line and the accounting being in double counterpart, I don't know how to add a line for each rows

example 1: my file

row 1 : customer|CPDUPONT||186.33

after job

row1: custumer|CPDUPONT|D|186.33

row2: product|7061000|C|186.33

exemple 2 :

row1 :customer|CPDUPONT||-186.33

after job

row1:custumer |CPDUPONT|C|186.33

row2:product |7061000|D|186.33

If someone help please

Thank a lot

François

Re: add rows after each rows

Anonymous — Mon, 02 May 2022 11:13:11 GMT

Where the row2's data comes? such as product|7061000|C|, are they fixed value? Basically, you need to iterate each row using tFlowToIterate component, and then generate the current row and a new row.

Regards

Shong

Re: add rows after each rows

FDufour1645879933 — Wed, 25 May 2022 12:42:15 GMT

thank you