All,
I have a source IDoc going to XI. For example it contains source fields SF1 (required), SF2 (required), SF3(optional) and SF4(optional).
I want to produce a target file using file content conversion. I want to produce target fields TF1(required), TF2(required), TF3(optional), and TF4(optional). In my mapping SF1 maps to TF1, SF2 maps to TF2, etc...
I want to produce a comma separated file, I am using file content conversions and I am using NameA.fieldSeparator (using a comma) in my file content conversion parameters. I have no problem when all 4 source fields are populated. In this case if the value of my source fields are: ABC 123 XYZ and 789 then I get a flat file with the result:
ABC,123,XYZ,789
The problem is when my optional fields are blank I currently get the following in my csv file:
ABC,123
When instead I want:
ABC,123,,
I know I've seen threads relating to this issue but I haven't had any success locating them. Any insight is appreciated.