Hi Team,
I am new to talend. I want to have multiple fixed width text file output based on rownumber from an oracle table. What component I need to use? The o/p should be like this
aaa 123 @##
bbb 456 *&^
ccc 780 *^%
ddd 987 $%&
EOF
Please help. Note for the EOF at the end of each text files.
Thanks,
Vishal
I want to have multiple fixed width text file output based on rownumber from an oracle table.
For fixed length file, we provide
tFileOutputPositional component.
Perhaps the work flow should be: tOracleInput-->tFileOutPutPositional
Best regards
Sabrina
Hye Sabrina, Thanks for the reply. But i already tried with outputpositional component. It gives results like aaa 123 #$% bbb 345 &%# ccc 123 #$% ddd 234 #$@ This is not the exact output that I want. Please help. Thanks, Vishal
Hye Sabrina,
The input is a table from oracle with fixed length size columns. I want the output also in fixed width text files. I am not sure how to attach a screenshot. I am telling you my tFileOutPutPositional setting. In Basic Setting tab -
Row seperator - "\n"
Formats - Column Size Padding Char Alignment Keep
Name 20 '' Left All
Number 10 '' Left All
Address 28 '' Left All
The thing is, it's taking the column width but it's not taking the row seperator in the output text file. Instead of inserting a new row into new line it's writing in the same line with '?' in between. The output is like
aaa 123 #$%?bbb 345
&%#?ccc 123 #$%?
ddd 234 #$@
I want the output in the below form:
aaa 123 @##
bbb 456 *&^
ccc 780 *^%
ddd 987 $%&
EOF
Thanks
Ooo Thanx a lot. The output is coming in fixed width now. But there is still one problem. The last column is not generated in the output text file. Can there be any reason for that?? Previously it was coming. Thanx for the help so far.
