Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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