Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
FDufour1645879933
Contributor
Contributor

add rows after each rows

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

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi

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

 

View solution in original post

2 Replies
Anonymous
Not applicable

Hi

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

 

FDufour1645879933
Contributor
Contributor
Author

thank you