We have the target .txt file,when opened the same in excel we see some problems.
eg F1,F2,F3,F4& F5 are the five fields,if all the fileds are present ,there is no layout problem,suppose there is no F3,F4 fields say in the input sent then the out put seen is F1,F3,F5 THE OUT PUT EXPECTED is F1,BLANK,F3,BLANK,F5.
This not the only case any field may anot come from the input from five
for this five field i used the elow mapping if F1 =! null then F1 else constant (if f1 is 8 chars ,i am leaving 8 spaces) with this the output seen is.
F1,F2,Blank,F5.
Content conversion parameters.
ignoreRecordsetName true.
Records.fieldNames F1,F2,F3,F4& F5
Records.fieldSeparator'0x09'
Rows.endSeparator'nl'
Thanks,
Srinivasa