In this file
card type , currency code,category, tran cd, ica, fee, program,count,tran am, tran fee, interchange-in, interchange out --all these are header...
for interchange in page 2 have 3 rows,,,all three rows should have "interchange in" hardcoded in the interchange_in column
for page 3,, 4 rows are of interchange in and 2 rows of interchange out.
How can i achieve this through talend.
o/p should look like:
