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
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.